converting a single row to multiple rows
Posted: Thu Jun 02, 2011 12:14 pm
I have the data coming in as below
col1 col2 col3 col4
Jay x x
kay x x
output :Insert into DB2 table using ODBC
jay col2
jay col4
kay col2
kay col3
Since we have only 8.1 version..I was thinking for having a transformer stage with 3 outputs each having a constrain on cols2,col3 col4 respectively.
Since am brand new to data stage , curious to know if this could be done by other methods and their merits..
col1 col2 col3 col4
Jay x x
kay x x
output :Insert into DB2 table using ODBC
jay col2
jay col4
kay col2
kay col3
Since we have only 8.1 version..I was thinking for having a transformer stage with 3 outputs each having a constrain on cols2,col3 col4 respectively.
Since am brand new to data stage , curious to know if this could be done by other methods and their merits..