Search found 4 matches
- Fri Oct 03, 2008 6:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get matched records between two columns
- Replies: 15
- Views: 6711
Re: How to get matched records between two columns
Hi, I have two columns in my source table Key_Pln_N and key_pln and my reference table column is key_pln_n1. now, i want to compare with key_pln_n1 and Key_Pln_N. If there is any unmatched records between these two columns i have to populate those records in to my dataset. Plz help me to resolve th...
- Fri Oct 03, 2008 6:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get matched records between two columns
- Replies: 15
- Views: 6711
Re: How to get matched records between two columns
Hi, I have two columns in my source table Key_Pln_N and key_pln and my reference table column is key_pln_n1. now, i want to compare with key_pln_n1 and Key_Pln_N. If there is any unmatched records between these two columns i have to populate those records in to my dataset. Plz help me to resolve th...
- Thu Jul 24, 2008 6:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deleting Datasets
- Replies: 10
- Views: 4019
- Wed Jul 16, 2008 1:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivot Logic
- Replies: 12
- Views: 3586
Pivot logic
Thanks for the reply, i am more concerned about the pivoting logic. It appears that the suggestion here is that you handle, the number of AMTs n outside a pivot stage using a transformer and then pivot the output using the pivot. There is no way I know to change the derivation of the pivot at runti...