Search found 9 matches
- Sun Jul 24, 2011 10:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RCP column order
- Replies: 5
- Views: 2686
- Sun Jul 24, 2011 8:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job reports failure (code 11)
- Replies: 5
- Views: 5460
- Sun Jul 24, 2011 8:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delete records generation from before dataset issue?
- Replies: 4
- Views: 2185
- Sun Jul 24, 2011 5:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delete records generation from before dataset issue?
- Replies: 4
- Views: 2185
Delete records generation from before dataset issue?
The problem was i was not able to get delete records out of the change capture.im getting a null value for all th columns in the record which was designated as a delete record.
can any one suggest me that why the values are empty?
can any one suggest me that why the values are empty?
- Sat Sep 25, 2010 12:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best approach to design?
- Replies: 6
- Views: 2939
- Fri Sep 24, 2010 9:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best approach to design?
- Replies: 6
- Views: 2939
- Fri Sep 24, 2010 7:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best approach to design?
- Replies: 6
- Views: 2939
I have got the solution in SQL. Here Value1,Value2,Value3 Columns Values are numbers from source Select Emp,SValues,Sum(Case when COL_NM='A1' Then Sdummy Else Null End) AS A1, Sum(Case when COL_NM='A2' Then Sdummy Else Null End) AS A2, Sum(Case when COL_NM='A3' Then Sdummy Else Null End) AS A3 FROM ...
- Sun Sep 19, 2010 8:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best approach to design?
- Replies: 6
- Views: 2939
- Sat Sep 18, 2010 3:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best approach to design?
- Replies: 6
- Views: 2939
Best approach to design?
Hi experts, I have requirement below. I mean that the output table columns are dynamic i.e A1..........An EMP COL_NM value1 value2 value3 ==== ===== ==== ==== ==== 100 A1 "NAME" 100 A2 100.00 200 A1 "NAME1" 200 A3 "Y" OUTPUT TABLE ========== EMP VALUES A1 A2 A3 A4 A5 .....