XML Parsing in datastage and Oracle
Posted: Mon Dec 10, 2012 11:59 pm
Hi All,
We have a couple of jobs which read XML data from DB2 and loads into oracle.
datastage is being used to extract the data and do parse the XML data into tabular format and load it into Oracle.
These jobs are running for 4 hours each.
What i am planning to do now is to load the data from DB2 to Oracle and do the XML parsing in the Oracle query.
the amount of data is approximatly 24000000 records.
wanted to check if this will give any kind of benifit.
Thanks in Advance,
Samyam
We have a couple of jobs which read XML data from DB2 and loads into oracle.
datastage is being used to extract the data and do parse the XML data into tabular format and load it into Oracle.
These jobs are running for 4 hours each.
What i am planning to do now is to load the data from DB2 to Oracle and do the XML parsing in the Oracle query.
the amount of data is approximatly 24000000 records.
wanted to check if this will give any kind of benifit.
Thanks in Advance,
Samyam