what is the main differences between Lookup, Join and Merge
stages?
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 y read Sequential file from job control?
What is merge stage?
in oracle target stage when we use load option and when we use upsert option?
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.
What is the difference between an operational datastage and a data warehouse?
how to abort the job its matain duplicates?
Can you highlight the main features of ibm infosphere information server?
What is difference between symmetric multiprocessing and massive parallel processing?
How do you generate sequence number in datastage?
What is the differentiate between data file and descriptor file?
Which commands are used to import and export the datastage jobs?
How many Key we can define in remove duplicate stage?
What is apt_config in datastage?
Define orabulk and bcp stages?
What is a datastage job?