what is the main differences between Lookup, Join and Merge
stages?
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
Can you explain repository tables in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is "fatal error/rdbms code 3996" error?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Explain the situation where you have applied SCD in your project?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
how to add a new records into source?
Terminate Activity
Explain datastage architecture?
What are some different alternative commands associated with "dsjob"?
Can you filter data in hashed file?
How the ipc stage work?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Is it possible to query a hash file?
describe the Steps to confiure a Qlogic switch