Interested to Buy Any Domain ? << Click Here >> for more details...
Input file one has data as shown below
1
2
3
4
5
6
7
8
Input file two has data like
6
7
8
9
10
11
Design a data stage job which will provide me three output files as shown below:
Output 1
6
7
8
Output 2
1
2
3
4
5
Output 3
9
10
11
Let me know your answers
- 4 Answers
- 6460 Views
- IBM, PR3 Systems, I also Faced
- E-Mail Answers
Answer Posted / sant532reddy
Use input file1 as after file and input file2 as before file to a change capture stage. Change capture stage generates change code 0 for 6,7,8 & 1 for 1,2,3,4,5 and 2 for 9,10,11. Use a filter/switch stage after change capture stage to write records to output file1 when change code is 0, to output file2 when change code is 1 and to output file3 when change code is 2.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is the use of surogate key in datastage
Can you define merge?
What are the partitioning techniques available in link partitioner?
What is usage analysis in datastage?
what is repositery?
Differentiate between Join, Merge and Lookup stage?
Distinguish between informatica & datastage. Which one would you choose and why?
how to delete one row in target dataset
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Can you filter data in hashed file?
Define data aggregation?
Can you explain repository tables in datastage?
What is a quality stage in datastage tool?
What is difference between server jobs & parallel jobs?
What is the purpose of pivot stage and types of containers in datastage
