Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149005 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rahul
all the three stages are differ with each other mainly
depends on three categories
1)input column requirements
a) sorting
b)de duplication
2)treatment of unmatched data
3)memory usage
1.. sorting in joins and merge in primary table and
secondary table is mandatory where in look up its optional.
de duplication in joins its allowed no warnings and no
job aborts.
in case of look up in primary table its accepted but in
secondary it raises warnings.
in merge primary table raises warnings in secondary
table its accepted.
about treatment of unmatched data and about memory discussed
above by some one..
thank you
| Is This Answer Correct ? | 19 Yes | 7 No |
Post New Answer View All Answers
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the purpose of pivot stage and types of containers in datastage
Distinguish between informatica & datastage. Which one would you choose and why?
How to read multiple files using a single datastage job if files have the same metadata?
What is job control?
What is process model?
What are the types of views in datastage director?
What is datastage engine?
project Steps,hits, Project level HArd things,Solved methods?
In Datastage, how you can fix the truncated data error?
how to write server Routine coding?
what is the use of skid in reporting?
Differentiate between Join, Merge and Lookup stage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Define Data Stage?
