DSXchange

Yes Ernie, that works when written by XML output as you said which is if I give filename.xml in the file path of XML output it is generating filename.xml,filename1.xml,filename2.xml....but if I give sequential file and give the same path all the 3 rows are combining into filename.xml.... What change...

Thank you Ernie! In the XML_Output stage under stage-->Options--->Write to file where I gave path and the number of files are generated based on the trigger column. But if I follow the same by giving an output link from the XML output to a sequential file then only 1 file is created with all the XML...

I used a sort stage before a transformer and then the XML output stage. I sorted using ACC_NO and processed the flow in sequential rather than parallel for the sort stage, transformer and XML output stage. Used the same trigger_column option and three files have been generated. Now I need to load th...

Thank you, so you mean to sort it based on the acct column and send into XML output stage....any options to be changed in the XML output stage.....to generate XML...files?

I am getting the input as XML and parsing it, which is giving the below records.. Name key Acct ABC 123 111 DEF 456 111 GHI 789 333 JKL 712 222 MNO 765 222 I am sending all these records into XML output stage to form 3 XML files based on the acct number i.e. 111 acct value records will go into one X...

Tried different ways but did not work. So created a small job to insert account numbers in one file and sending each account number at a time to the job to do the transformations and loading the records. Thought to use two jobs than doing all the requirements in one job.

When taken the same records given below as example our requirement is the account number 111 which has 2 records should go first as they will combine and form an XML column which will be inserted into the table as one record and later the 333 which has 1 record will go into one XML and get inserted ...

Thank you Ray Actually I did start and followed a process but it did not work, what I did is used looping in transformer like below In the input transformer I sorted the with the Account number and used 3 stage variables StageVar1: Name is NumSavedRows Derivation is SaveInputRecord() StageVar2: Name...

I have a requirement where I need to send records in groups to the table. Below is the example Name Phone Acct ABC 123 111 DEF 456 111 GHI 789 333 JKL 712 222 MNO 765 222 the input from the source is this and I need to send only records which have same account number at a time like 111 has 2 records...

The way which Ernie suggested worked for me, loaded the XML CLOB into a file and then parsed it with XML input stage but I have around 15 more transformations to do which should include CLOB column and other columns of the table. So it needs to be a single job, that is the reason I was asking for pa...

Thank you very much, will implement the same with two jobs.

So my assumption is XML cannot be parsed directly from the CLOB field of Table?

Actually when waiting for the solution for the issue, I tried some options and was updating the output each time I made changes. Now I get the output from the job in first post as wanted but only when I use External source.My requirement is to get the same output when I read the CLOB field informati...

I removed the text() after / which made the derivation ending with / but still I get the warning and the records are not passing after XML input stage. Below are the warnings XML input document parsing failed. Xalan fatal error (publicId: , systemId: , line: 2, column: 2): Invalid character (Unicode...

Thank you Ernie!

So if the whole tags are retrieved , I can get the output when pulled from the DB. How do I get the whole tags, when importing do I need to select something?
as you said when I see the description it ends in /text(), please suggest how to retrieve the whole tags?

There is some issue with the main tag which is the ID. Now after using it as ID I got the right output when pulling the XML from file which has its data loaded from a table. When reading the same CLOB field from the DB directly, it is throwing an error which says "Xalan fatal error" due to...