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
- 7576 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
Where the datastage stored his repository?
How do u convert the columns to rows in datastage?
What are stage variables and constants?
sed,awk,head
Why we use surrogate key?
Differentiate between Join, Merge and Lookup stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How can one find bugs in job sequence?
What is datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the purpose of pivot stage?
What are the steps needed to create a simple basic datastage job?
How to read the length of word in unix?
