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
- 18257 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
What are the important features of datastage?
Explain the importance of surrogate key in data warehousing?
What are the different type of jobs in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
what are the devoleper roles in real time? plz tell i am new to datastage....
table actions available in oracle connector?
What are stage variables?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is a datastage job?
How many Key we can define in remove duplicate stage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the repository tables in datastage?
How many types of sorting methods are available in datastage?
What are the functionalities of link partitioner?
What can we do with datastage director?
