I have a input as:
Col
1
1
2
2
3
I want 3 output as:
Output1:
1
1
Output2:
2
2
Output3:
3
i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
Answer Posted / sivakeshava
hi friends by seeing the source we need 3 targets....which id duplicates 1,1 is one target, and 2,2 is 2nd target and 3 is another target
Seqfile------------ >copy -------------- lookup(innerjoin) ------------- filter
Aggregator---------------- > filter
(count) where clause
copy to aggregate then filter to lookup then will give 3 targets
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between the local container and shared container?
What is the sortmerge collector?
How a routine is called in datastage job?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
how to write server Routine coding?
What are the different types of lookups in datastage?
Where the datastage stored his repository?
What is use Array size in datastage
What are the processing stages?
What is the difference between datastage and datastage tx?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is datastage?
What are system variables and sequencers in datastage
How many Key we can define in remove duplicate stage?
How to clean the datastage repository?