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
What is a folder? Difference types of stages?
If you want to use a same piece of code in different jobs, how will you achieve this?
Explain entity, attribute and relationship in datastage?
What is usage analysis in datastage?
How rejected rows are managed in datastage?
What are stage variables, derivations and constants?
Can we use target hash file as a lookup ?
what is the use of materialized view?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the difference between operational data stage (ods) and data warehouse?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How can we improve the performance in datastage?
What is merge stage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are data elements?