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



what is the difference between lookup stage reject link and merge stage reject link in datastage P..

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

what is the difference between lookup stage reject link and merge stage reject link in datastage P..

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

what is the difference between lookup stage reject link and merge stage reject link in datastage P..

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

what is the difference between lookup stage reject link and merge stage reject link in datastage P..

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

Post New Answer

More Data Stage Interview Questions

What are constraints and derivations?

0 Answers  


Define data aggregation?

0 Answers  


what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,


How many types of stage?

0 Answers  


what is a force compile

2 Answers   Cap Gemini, IBM,






Difference between server jobs & parallel jobs?

0 Answers  


What are the prerequisites for join stage

2 Answers  


Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  


in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,


Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5

2 Answers   IBM,


How will you move hashed file from one location to another location?

0 Answers   NTT Data,


What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,


Categories