Facing Problem while usinh XML as source in DataStage 7.5
Posted: Fri Apr 13, 2007 8:17 am
I am developing a job where XML is used as a source.The traget table is RDBMS.
Now the XML source is containing the data like this:
<A>
<a>abc</a>
<b>123</b>
<c>q</c>
</A>
<B>
<d>2007</d>
<e>DP</e>
<f>-4</f>
</B>
<B>
<d>2006</d>
<e>DH</e>
<f>-3</f>
</B>
<B>
<d>2006</d>
<e>DJ</e>
<f>-2</f>
</B>
The columns are a,b,c,d,e,f
For a particular value of a,b,c the value of d,e,f are coming more than once.
So I need to populate this as 3 records in a table.
The metadata of XML file contains a,b,c,d,e,f columns.
So when I am running the job one record is inserted in table.
How can i populate 3 records in a table?
Please suggest.
Now the XML source is containing the data like this:
<A>
<a>abc</a>
<b>123</b>
<c>q</c>
</A>
<B>
<d>2007</d>
<e>DP</e>
<f>-4</f>
</B>
<B>
<d>2006</d>
<e>DH</e>
<f>-3</f>
</B>
<B>
<d>2006</d>
<e>DJ</e>
<f>-2</f>
</B>
The columns are a,b,c,d,e,f
For a particular value of a,b,c the value of d,e,f are coming more than once.
So I need to populate this as 3 records in a table.
The metadata of XML file contains a,b,c,d,e,f columns.
So when I am running the job one record is inserted in table.
How can i populate 3 records in a table?
Please suggest.