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
- 13607 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
Differentiate between datastage and datastage tx?
What are stage variables?
describe the Steps to confiure a Qlogic switch
explain about citrix scheduling tool in datastage
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
On which Dimension Table you implemented SCD Type in your Project
What is the flow of loading data into fact & dimensional tables?
I have a few records just I want to store data in to targets cycling way how?
What could be a data source system?
State the difference between an operational datastage and a data warehouse?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Why we use surrogate key?
How do you import and export data into datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
how to write server Routine coding?
