Interested to Buy Any Domain ? << Click Here >> for more details...
INPUT file 'A' contains:
1
2
3
4
5
6
7
8
9
10
input file 'B' contains:
6
7
8
9
10
11
12
13
14
15
Output file 'X' contains:
1
2
3
4
5
Output file 'Y' contains:
6
7
8
9
10
Output file 'Z' contains:
11
12
13
14
15
How can we implement this in a single ds job?
- 11 Answers
- 19098 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / vaibhav
Hi Subbuchamala..
I marked this ans as no bcoz CDC stage works row by row i.e. on key column basis.. here for all the 10 records change_code will be 3 so it cannot be differentiated into 3 target files...
Different approach will be.. take union of 2 input tables and use transformer stage and filter on the basis of rownumber..
Let me know if I am wrong..
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Differentiate between datastage and informatica?
What is a datastage job?
How many types of stage?
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?
how to sort two columns in single job in datastage.
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are data elements?
what is flow of project?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How one source columns or rows to be loaded in to two different tables?
How we can covert server job to a parallel job?
Differentiate between hash file and sequential file?
On which interface you will be working as a developer?
Does datastage support slowly changing dimensions ?
How do you remove duplicate values in datastage?
