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
- 6705 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
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 one source columns or rows to be loaded in to two different tables?
Define project in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
How a server job can be converted to a parallel job?
How you can fix the truncated data error in datastage?
Explain how a source file is populated?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How do you start developing a datastage project?
Describe routines in datastage? Enlist various types of routines.
What is a ds designer?
How rejected rows are managed in datastage?
How many Key we can define in remove duplicate stage?
Describe the main features of datastage?
What are some different alternative commands associated with "dsjob"?
