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
- 11221 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sher
something like below should work...
Job#1
Read in transformer to add a new column sequence the value of sequence will be initially 1 and increment when key changes…
so output(A) will look like…
1 1
1 1
2 2
2 2
3 3
4 4
B 5
under job sequence, use a job activity to read(A) use tail -1 and | cut to read 2nd column. we get 5..
Now, use start loop activity and end look activity stage in job sequence to create a loop from 1 to jobactivity.output incrementing by 1..
The look will now run 5 times.. inside the loop, call a job and pass the value i.e 1,2,3,4,5 each time it runs.
Inside the called job, read the input file(A) pass to transformer and then use constraint to write only records where 2nd column = variable passed and drop column 2..
Output of transformer.
1st loop output
1
1
2nd loop output
2
2
and so on...
when writing the file, use the passed variable in file name, so file name is distinct
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to read the length of word in unix?
What are datastage sequences?
What is a ds designer?
Can you define merge?
Whats difference betweeen operational data stage (ods) and data warehouse?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the difference between an operational datastage and a data warehouse?
I have a few records just I want to store data in to targets cycling way how?
Difference between in process and inter process?
table actions available in oracle connector?
what is flow of project?
What is the difference between datastage and datastage tx?
What are data elements?
How do you schedule or monitoring the job?
how to add a new records into source?
