Hello CloverETL Users, I have a question on
I am trying to load the XML produced in XMLWriter into the Oracle table which is of below structure
ID NUMBER(16,0)
PRIOR_TRANSACTION_ID VARCHAR2(30 BYTE)
CREATE_DATE DATE
UPDATE_DATE DATE
ERROR_CODE VARCHAR2(50 BYTE)
PAYLOAD CLOB
I am able to load the CLOB column alone by connecting the output port of XMLWriter to DBOutputtable , But how can I bring the other columns associated and write them into the table at the same time.
i.e. How I can load
ID,PRIOR_TRANSACTION_ID,CREATE_DATE,UPDATE_DATE and ERROR_CODE from other sources and XML produced from XMLwriter as PAYLOAD to the oracle table .
Any quick response will be really appreciated.
I am trying to load the XML produced in XMLWriter into the Oracle table which is of below structure
ID NUMBER(16,0)
PRIOR_TRANSACTION_ID VARCHAR2(30 BYTE)
CREATE_DATE DATE
UPDATE_DATE DATE
ERROR_CODE VARCHAR2(50 BYTE)
PAYLOAD CLOB
I am able to load the CLOB column alone by connecting the output port of XMLWriter to DBOutputtable , But how can I bring the other columns associated and write them into the table at the same time.
i.e. How I can load
ID,PRIOR_TRANSACTION_ID,CREATE_DATE,UPDATE_DATE and ERROR_CODE from other sources and XML produced from XMLwriter as PAYLOAD to the oracle table .
Any quick response will be really appreciated.
-
Hello jinojohn,
I think the component you are looking for is Combine, http://doc.cloveretl.com/documentation/ ... mbine.html
It is able to join records in two separated input streams according to the order. The first record in input A is joined to the first record in input B, the second one in A is joined to the second one in B and so on...
Does this solution meet your requirement?
Kind regards,
Please sign in to leave a comment.
Comments 1