Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149286 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
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are datastage sequences?
What is ibm datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the differences between datastage and informatica?
How to read the length of word in unix?
How the ipc stage work?
How can you write parallel routines in datastage PX?
What are system variables and sequencers in datastage
Difference between server jobs & parallel jobs?
What all the types of jobs you developed?
What is ibm datastage flow designer?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the job parameters?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
