Question { IBM, 5269 }

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

Answer

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.

Question { IBM, 5269 }

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

Answer

seq file1 and file2 as input to change capture stage and then a switch stage with case=0,1,2 (on change code). Case=0 will give 6,7,8. Case=1 will give 1,2,3,4,5 and case=2 will give you 9,10,11