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
- 13608 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
Could anyone give brief explanation bout datastage admin
What are orabulk and bcp stages?
What is use Array size in datastage
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the different common services in datastage?
What are the functionalities of link partitioner and link collector?
Explain datastage architecture?
How many areas for files does datastage have?
Define APT_CONFIG in Datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How you can fix the truncated data error in datastage?
What is usage analysis in datastage?
Why do you need stage variables?
What is the purpose of interprocessor stage in server jobs?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
