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?
- 3 Answers
- 6800 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Difference between sequential file and data set?
Difference between the Sequence and Sequencer in DS?
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How do you find the number of rows in a sequential file?
Why we use parameters instead of hard code in datastage.
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
What is the difference between orabulk and bcp stages?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
How the ipc stage work?
options available in sequence job to run,validate?
what is Audit table?Have u use audit table in ur project?
Teradata 
