Answer / rajeshchunduri

In lookup stage reject link gets data of unmatched primary.
wear as in merge secondry unmatched data comes to reject
link. merge supports n-1 reject links

Answer / xxx

In Lookup reject link we can capture the source rejected
data.

In merge reject link we can capture updated table rejected
data.

Answer / kiran

Reject link is a reject link in both merge and lookup
stage. I guess the interviewer is not sure about this
question. The difference between lookup and mergre stages
in terms of reject links is lookup allows single reject
while merge allows as many reject links as the update links
in the source. so Lookup---> single reject link, Merger--->
Multiple reject links.

Answer / dilip anand k

Look up has one Primary input and several reference inputs
and it supports an optional reject link that captures the
unmatched data looked up in the primary. (Rejected data in
the primary input and not the referential links)

Merge stage has one Master input and several update
datasets and it has a reject link for each update link
specified. So if we have ‘n’ no of update datasets then the
stage supports ‘n’ no. of reject links to capture the
unmatched records of the update link.

Answer / ashok

lookup support only one reject link.
merge support zero or n-1 reject links.

Answer / sravanthi agarwal w/o.sai sat

In Lookup stage we can capture the primary reject data
(input link to the lookup) and its only 1 link..


In case of Merge stage we can capture secondary rejected
data(depends on update links to the merge stage) and its
depends on update link count.....

Answer / vijaya

Hi

The lookup stage contain one primary link and another
ref.link the reject link will have unmatched records of
primary link.where as in merge stage contain one master link
all update links the reject link will have unmatched records
of update link.

Answer / shar

Well
The prime difference is
lookup reject link can collect all unmatched primary mismatched data.
Where as
in merge stage, using reject link(s) it will allow us to identify from which update datasets records got rejected.
n in addition to this as we know
lookup supports only one reject link and merge supports as many no. of updates so many no. of reject links.
thats it.

Answer / narayana

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 ?

What are some prerequisites for datastage?

0 Answers  

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

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.

1 Answers   CGI,

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,

How did you reconcile source with target?

3 Answers   HP,

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

Where the datastage stored his repository?

0 Answers  

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 Answers  

why we use parameters instead of hard code in datastage

4 Answers   HCL,

root tree will find which is server job and which is parallel job?

0 Answers   IBM,