We have moved to www.dataGenX.net, Keep Learning with us.

Tuesday, January 21, 2014

DataStage Scenario - Problem8


Goal : Distribute the data as below condition -

Given : FileA and FileB contains some data in single column.
Target : File_A : Which contains the data which is available in A but not in B
Target : File_B : Which contains the data which is available in B but not in A
Target : File_AB : Which contains the data which is available in A and B Both




FileA FileB
1 9
2 10
3 11
4 12
5 13
6 14
7 15
8 16
9 17
10 18
11 19
12 20
13 21
14 22
16 23



OutPut  

File_A File_B File_AB
1 17 9
2 18 10
3 19 11
4 20 12
5 21 13
5 22 14
6 23 15
7
16
8

No comments :

Post a Comment