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
- 13956 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 one source columns or rows to be loaded in to two different tables?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Difference between in process and inter process?
How do you reject records in a transformer?
Define Data Stage?
Explain Quality stage?
Describe stream connector?
What is datastage?
What are the job parameters?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the areas of application?
how can we create rank using datastage?what is the meaning of rank?
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?
