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
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 |
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 |
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 |
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 |
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
on how many columns we can perform aggregation in the aggregator stage?
I have a few records just I want to store data in to targets cycling way how?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?
6 Answers CTS, HCL, IBM, Wipro,
what is sparse lookup?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
How a server job can be converted to a parallel job?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are the different types of lookups in datastage?