Search found 4 matches

by Kris123
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...
by Kris123
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...
by Kris123
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

To delete dataset at command line you need to invoke the osh shell (environment) and then use the Orchadmin rm <dataset> command.
Review Orchadmin -help to see all the available options.
by Kris123
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...