Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149253 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / jana520
all are used to join tables , but
lookup: when the reference data is very less we use lookup.
bcoz the data is stored in buffer. if the reference data is
very large then it wl take time to load and for lookup.
join: if the reference data is very large then we wl go for
join. bcoz it access the data directly from the disk. so the
processing time wl be less when compared to lookup. but here
in join we cant capture the rejected data. so we go for merge.
merge: if we want to capture rejected data(when the join key
is not matched) we use merge stage. for every detailed link
there is a reject link to capture rejected data.
| Is This Answer Correct ? | 51 Yes | 11 No |
Post New Answer View All Answers
How do you import and export data into datastage?
What are iconv and oconv?
what is repositery?
What is the use of hoursfromtime() function in transformer stage in datastage?
In Datastage, how you can fix the truncated data error?
Differentiate between datastage and datastage tx?
How many areas for files does datastage have?
What are the job parameters?
how to add a new records into source?
Explain the importance of surrogate key in data warehousing?
Can you implement SCD2 using join, transformer and funnel stage?
Difference between in process and inter process?
Difference between sequential file and data set?
How can one find bugs in job sequence?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
