Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149003 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
What is the difference between informatica and datastage?
Why we use surrogate key?
How and where you used hash file?
Could anyone give brief explanation bout datastage admin
Is possible to create skid in dim,fact tables?
EXPLAIN SCD
What are system variables and sequencers in datastage
What is the purpose of pivot stage and types of containers in datastage
What are the types of hashed files in data stage
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How the ipc stage work?
What are the steps needed to create a simple basic datastage job?
What a datastage macro?
What is the purpose of pivot stage?
Can you define merge?
