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 ?
Answers were Sorted based on User's Feedback
Answer / sharan
Lookup stage reject link captures unmatched primary entries
and Merge stage reject links captures unmatched secondary
entries.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / sharan
Lookup stage reject link captures unmatched primary entries
and Merge stage reject links captures unmatched secondary
entries.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / bharath
Lookup stage reject link captures unmatched primary entries
and Merge stage reject links captures unmatched secondary
entries.
In lookup stage only one reject link and one ref link is possible, where as in merge, n ref having n rejects...
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
how to remove duplicates in transformer stage by using stage variables?one example?
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
Can you explain repository tables in datastage?
How can one find bugs in job sequence?
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
What r the existing server jobs in parallalism?
What is the precedence of stage variables,derivations, and constraints?
What is the difference between in process and inter process?
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
What are orabulk and bcp stages?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....