Search found 1 match
- Mon Mar 30, 2009 8:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to convert form Rows into Columns
- Replies: 5
- Views: 4554
How to convert form Rows into Columns
Hi all, I am loading an XML file which contains about 10,000 records. I am using DS 7.5.1A PX jobs on UNIX platform. These XML files are to be loaded in the SQL Server DB. After parsing the XML file using DS job got the following output Dataset. Ex: Seq_ID, Field_Name, Value 1, Gender, Male 1, Age, ...