what is the difference between lookup stage reject link and
merge stage reject link in datastage Parallel jobs? interm
of output in Merge Reject link and Look Up Reject link ?
Answer Posted / pnvnreddy
Lookup stage reject link captures unmatched primary entries and Merge stage reject links captures unmatched secondary entries.
In lookup stage have only one reject link where as in merge stage if we have n updates then it will support zero or n reject links(in between zero to n doesnt accept)
Here Update1 unmatched secondary records will capture at reject1, Update2 will capture reject2..... so on.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Enlist various types of routines in datastage.
What is a datastage job?
what is use of SDR function?
What are system variables and sequencers in datastage
in oracle target stage when we use load option and when we use upsert option?
What is difference between symmetric multiprocessing and massive parallel processing?
Why fact table is in normal form?
What is datastage engine?
How many areas for files does datastage have?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How do you import and export data into datastage?
Difference between sequential file and data set?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are orabulk and bcp stages?
How do you remove duplicate values in datastage?