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
- 6799 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How will you move hashed file from one location to another location?
What are the differences between datastage and informatica?
Explain connectivity between datastage with datasources?
Why fact table is in normal form?
What are the types of jobs we have in datastage?
What is the project in datastage?
What is the roundrobin collector?
What are the functionalities of link partitioner and link collector?
How a routine is called in datastage job?
What is the purpose of pivot stage and types of containers in datastage
Differentiate between data file and descriptor file?
Where do you see different stages in the designer?
What is the purpose of interprocessor stage in server jobs?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
