Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 148588 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / aishwarya
Join Stage:
1.) It has n input links(one being primary and remaining
being secondary links), one output link and there is no
reject link
2.) It has 4 join operations: inner join, left outer join,
right outer join and full outer join
3.) join occupies less memory, hence performance is high in
join stage
4.) Here default partitioning technique would be Hash
partitioning technique
5.) Prerequisite condition for join is that before
performing join operation, the data should be sorted.
Look up Stage:
1.) It has n input links, one output link and 1reject link
2.) It can perform only 2 join operations: inner join and
left outer join
3.) Join occupies more memory, hence performance reduces
4.) Here default partitioning technique would be Entire
Merge Stage:
1.) Here we have n inputs master link and update links andn-
1 reject links
2.) in this also we can perform 2 join operations: inner
join, left outer join
3.) the hash partitioning technique is used by default
4.) Memory used is very less, hence performance is high
5.) sorted data in master and update links are mandatory
| Is This Answer Correct ? | 61 Yes | 13 No |
Post New Answer View All Answers
What is ibm datastage flow designer?
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?
State the difference between an operational datastage and a data warehouse?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the different type of jobs in datastage?
What is the process of killing a job in datastage?
what is repositery?
What are the different plug-ins stages used in your projects?
Could anyone give brief explanation bout datastage admin
What is a folder? Difference types of stages?
How a source file is populated?
How a server job can be converted to a parallel job?
Where do the datastage jobs get stored?
How rejected rows are managed in datastage?
What all the types of jobs you developed?
