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
- 7436 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
Differentiate between datastage and informatica?
What is the difference between account and directory options ?
What is ds designer?
What is the precedence of stage variables,derivations, and constraints?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Differentiate between operational datastage (ods) and data warehouse?
Is possible to create skid in dim,fact tables?
What are the steps needed to create a simple basic datastage job?
What is orabulk stage?
What steps should be taken to improve Datastage jobs?
Where the datastage stored his repository?
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
What is datastage?
How do you reject records in a transformer?
How the ipc stage work?
