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
- 7437 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of interprocessor stage in server jobs?
Explain the importance of surrogate key in data warehousing?
what is the custome stage in datastage? how can we impliment that one? plz tell me
whom do you report?
What is the difference between an operational datastage and a data warehouse?
What are the types of containers in datastage?
Name the different types of Lookups in Datastage?
Can you implement SCD2 using join, transformer and funnel stage?
how to delete one row in target dataset
What are the types of jobs we have in datastage?
Differentiate between operational datastage (ods) and data warehouse?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Why do you need stage variables?
What is the differentiate between data file and descriptor file?
Differentiate between data file and descriptor file?
