Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 13888 Views
- IBM, I also Faced
- E-Mail Answers
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
How a source file is populated?
Is it possible to query a hash file?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the difference between validated and compiled in the datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
how can we create rank using datastage?what is the meaning of rank?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Differentiate between validated and Compiled in the Datastage?
What is quality stage?
What is the differentiate between data file and descriptor file?
What are the types of containers in datastage?
What is difference between server jobs & parallel jobs?
What are the some differences between 7.x and 8.x version of datastage?
What are the difference types of stages?
