Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between lookup stage reject link and
merge stage reject link in datastage Parallel jobs?
- 9 Answers
- 28407 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / xxx
In Lookup reject link we can capture the source rejected
data.
In merge reject link we can capture updated table rejected
data.
| Is This Answer Correct ? | 13 Yes | 1 No |
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.
| Is This Answer Correct ? | 17 Yes | 8 No |
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.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / ashok
lookup support only one reject link.
merge support zero or n-1 reject links.
| Is This Answer Correct ? | 7 Yes | 0 No |
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.....
| Is This Answer Correct ? | 4 Yes | 0 No |
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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 ?
| Is This Answer Correct ? | 2 Yes | 6 No |
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
Explain the importance of surrogate key in data warehousing?
What steps should be taken to improve Datastage jobs?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
How one source columns or rows to be loaded in to two different tables?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
What is a range lookup?
Define Job control?
Hi This is Vijay, How can your remove the duplicates in sequential File?
15 Answers HCL, Scope International,
What are the different database update actions available?
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
what is use of SDR function?
Teradata 
