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
- 14219 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
What are the types of containers and how to create them?
Define Routines and their types?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is staging variable?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
what is use of SDR function?
whom do you report?
Define ds designer?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Is the value of staging variable stored temporarily or permanently?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the benefits of datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
On which Dimension Table you implemented SCD Type in your Project
