Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 148997 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
How rejected rows are managed in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the use of hoursfromtime() function in transformer stage in datastage?
how to abort the job its matain duplicates?
What is the difference between informatica and datastage?
What is a merge?
What are routines in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Different ways a project can be moved to production ?...example ….export-import and Version control.
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is merge stage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is data partitioning?
what is flow of project?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
