what is the difference between lookup stage reject link and
merge stage reject link in datastage Parallel jobs?
Answer Posted / shar
Well
The prime difference is
lookup reject link can collect all unmatched primary mismatched data.
Where as
in merge stage, using reject link(s) it will allow us to identify from which update datasets records got rejected.
n in addition to this as we know
lookup supports only one reject link and merge supports as many no. of updates so many no. of reject links.
thats it.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
If you want to use the same piece of code in different jobs, how will you achieve it?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is staging variable?
What are the different common services in datastage?
What are the features of datastage flow designer?
Why do we use link partitioner and link collector in datastage?
Describe routines in datastage? Enlist various types of routines.
Differentiate between validated and Compiled in the Datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Can we use target hash file as a lookup ?
What a datastage macro?
Define Merge?
How to clean the datastage repository?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
On which Dimension Table you implemented SCD Type in your Project