I am trying to extract two columns from Oracle database, one of which is a CLOB field storing XMLs. The task I want to accomplish is to get those XMLs and then map the elements of the XML to columns of a dataset. Please guide me how to design the job to accomplish this. Thanks in advance.
I am using Datastage 8.5.
Extracting a CLOB field (XML) from an Oracle database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 4
- Joined: Thu Sep 08, 2011 10:02 am
- Location: Hyderabad
Extracting a CLOB field (XML) from an Oracle database
Regards,
Danish
Danish
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact: