XML data load to Oracle table with Metadata

CloverDX Platform
1

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.

2

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,