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 ?
- 4 Answers
- 12175 Views
- HCL, I also Faced
- E-Mail Answers
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 data partitioning?
How to reverse the string using unix?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is the process of killing a job in datastage?
What is the purpose of pivot stage and types of containers in datastage
How do you remove duplicate values in datastage?
project Steps,hits, Project level HArd things,Solved methods?
What is oci?
Differentiate between hash file and sequential file?
What is a merge in datastage?
how many rows sorted in sort stage by default in server jobs
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are iconv and oconv?
How you Implemented SCD Type 1 & Type 2 in your project?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
