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

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,


How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  


How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,


I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,






How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,


Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,


Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,


Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,


Terminate Activity

0 Answers   CTS,


What is the difference between informatica and datastage?

0 Answers  


How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,


Categories