what is the main differences between Lookup, Join and Merge
stages?
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 merge stage?
Give an idea of system variables.
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is the use of surogate key in datastage
What are transforms and what is the differenece between routines and transforms?
how to write server Routine coding?
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 the difference between server job and parallel jobs?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the method of removing duplicates, without the remove duplicate stage?
What is datastage engine?
what is flow of project?
What is the difference between passive stage and active stage?