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
- 18604 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
whom do you report?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How can one find bugs in job sequence?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What could be a data source system?
Explain datastage architecture?
In Datastage, how you can fix the truncated data error?
What is the difference between the local container and shared container?
Explain how a source file is populated?
CHANGE CAPTURE
What is difference between join, merge and lookup stage?
what is flow of project?
Why do you need stage variables?
Which commands are used to import and export the datastage jobs?
How many types of hash files are there?
