Search found 4 matches

by haryedru
Thu Nov 24, 2011 4:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Duplicates
Replies: 8
Views: 4512

Hi Upul and Ray sorry for giving the requirment wrong. So this means a simple transformer stage variable approach cannot be used. You'll need to fall back on the dreaded "fork join" design with the aggregator brach getting counts per key and then when joining back together only passing re...
by haryedru
Tue Nov 22, 2011 11:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Duplicates
Replies: 8
Views: 4512

Hi Upul and Ray sorry for giving the requirment wrong. this is my input ID,Term 1,CONTRACT_NUMBER 2,CONTRACT_NUMBER 3,CONTRACT_NUMBER 4,Account 5,Account_Currency_Code 6,Account_Currency_Code 7,Account_Analyst This should be my output ID,TERM 1,CONTRACT_NUMBER 2,CONTRACT_NUMBER 3,CONTRACT_NUMBER 5,A...
by haryedru
Tue Nov 22, 2011 12:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Duplicates
Replies: 8
Views: 4512

Removing Duplicates

Hi this is my input ID,Term 1,CONTRACT_NUMBER 1,CONTRACT_NUMBER 1,CONTRACT_NUMBER 2,Account 3,Account_Currency_Code 3,Account_Currency_Code 4,Account_Analyst This should be my output ID,TERM 1,CONTRACT_NUMBER 1,CONTRACT_NUMBER 1,CONTRACT_NUMBER 3,Account_Currency_Code 3,Account_Currency_Code If a re...
by haryedru
Sat Nov 19, 2011 3:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Vertical Pivot in Server Job
Replies: 1
Views: 2094

Vertical Pivot in Server Job

Hi I am looking for a solution to this... This is my input ID,COMPANY,LOCATION,PLACE 1,HCL,BANGLORE,MANYATTA 1,HCL,CHENNAI,NAVALUR 1,HCL,HYDERABAD,HITECHCITY 2,IBM,BANGLORE,MADIWALA 2,IBM,CHENNAI,RAMAPURAM This should be my output ID,COMPANY,BANGLORE,CHENNAI,HYDERABAD 1,HCL,MANYATTA,NAVALUR,HTTECHCI...