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
- 13717 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 to implement complex jobs in data stage?
Triggers,VIEW,Procedures
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is 'reconsideration error' and how can i respond to this error and how to debug this
What is quality stage?
What are the stages in datastage?
Differentiate between odbc and drs stage?
What is the difference between Datastage 7.5 and 7.0?
What is a ds designer?
client know skid info?
How to read the length of word in unix?
Can you explain tagbatch restructure operator?
Differentiate between datastage and datastage tx?
