Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7573 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 |
What a datastage macro?
Explain the situation where you have applied SCD in your project?
How do you generate sequence number in datastage?
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
how many types of remove the duplicate records?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
how to sort two columns in single job in datastage.
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
is it possible to access the same job by two users at a time in DataStage?
What is Cleanup Resources and when do you use it?
Define Data Stage?
Teradata 
