I am having the 2 source files A and B and I want to get the output as, the da

I am having the 2 source files A and B and I want to get the
output as, the data which is in file A and which doesn't in
file B to a target 1 and which is in file B and which doesn't
in file A to a target 2?

Question Posted / hemanth.datastage

3 Answers
7610 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I am having the 2 source files A and B and I want to get the output as, the data which is in file ..

Answer / chandra swain(hara)

mapping for above job

fileA---->joinstage---->transformer------->dataset1
^ ------>dataset2
|
|
fileB

go to joinstage ,take type of join is fullouter join,

then copy the i/p column to o/p link ,goto transformer stage
u 'll found 2 constraint tab ,in 1st constraint tab write
leftRec_column<>rightRec_column And LeftRec_column<>0,

similarly in 2nd constraint tab write
leftRec_column<>rightRec_column And RIGHTRec_column<>0

then copy only LeftRec_column to dataset1
and copy only RightRec_column to dataset2

i think u definitly get the correct answer

Is This Answer Correct ?

9 Yes

1 No

I am having the 2 source files A and B and I want to get the output as, the data which is in file ..

Answer / reddymkl.dwh

FullOuter
FileA------->Join--------->Filter-------->T1
| |
| |
| |
| |
FileB T2
Use Fullouter Join Then
Filter-------> Where =Right.link=''
Where =Left.link=''
Nothing but A-B, B-A scenario.

Plz correct me if am wrong.....

Is This Answer Correct ?

0 Yes

0 No

I am having the 2 source files A and B and I want to get the output as, the data which is in file ..

Answer / upputuri.vinod

I am going to explain with example.

A B T1 T2
1 1 2 7
2 7-----> Now according to the QA in 3 9
3 9 4 5.
4 5

i am going to use the lookup stage..

1-------LK2<----B
! !
! !
T2 A---->LK1------1

T1

here T1 is the rejected data from LK1 where T2 rejected data
from LK2.

The condition in LK is Reject.

I hope U got the point..

Is This Answer Correct ?

1 Yes

5 No

Post New Answer