External Source Stage with Multiple XML
Posted: Wed Nov 18, 2009 6:28 am
Hi,
Actually I am having 1000 xml in one folder and i need to process this all xml and load it into oracle db.
I have developed the job like below
RowGen -->Trans ---> XML Input ---> Oracle
in Sequencer, I am using ls -m command to take all the file with comma seperator and doing loop to load it into DB but I heared if i use External source stage then i put <code> ls *.xml </code> then datastage concate all the xml file and do the process at same time. is it TRUE?
I am suspecting because every XML have starting with some unwanted tags (ie) Namespace info as well if it concate then it may be wrong.
Please suggest me for moving to next step.
One more request from your guys,
any body having external source stage exact syntax for windows pls give me bcz i tried lot but not working.
Thanks & Regards
Pradeep
Actually I am having 1000 xml in one folder and i need to process this all xml and load it into oracle db.
I have developed the job like below
RowGen -->Trans ---> XML Input ---> Oracle
in Sequencer, I am using ls -m command to take all the file with comma seperator and doing loop to load it into DB but I heared if i use External source stage then i put <code> ls *.xml </code> then datastage concate all the xml file and do the process at same time. is it TRUE?
I am suspecting because every XML have starting with some unwanted tags (ie) Namespace info as well if it concate then it may be wrong.
Please suggest me for moving to next step.
One more request from your guys,
any body having external source stage exact syntax for windows pls give me bcz i tried lot but not working.
Thanks & Regards
Pradeep