Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 148582 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
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is datastage engine?
Can you implement SCD2 using join, transformer and funnel stage?
How the ipc stage work?
How to perform incremental load in datastage?
Explain the situation where you have applied SCD in your project?
How to Remove Duplicate using SQL?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the roundrobin collector?
Which commands are used to import and export the datastage jobs?
How can you write parallel routines in datastage PX?
What is difference between symmetric multiprocessing and massive parallel processing?
How many types of stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
