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
options available in sequence job to run,validate?
What are stage variables and constants?
what are the errors,warnings in datastage
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Differentiate between hash file and sequential file?
What is the difference between the local container and shared container?
What is difference between symmetric multiprocessing and massive parallel processing?
Explain usage analysis in datastage?
What are the various kinds of containers available in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the different types of lookups in datastage?
What is ibm datastage flow designer?
What is a folder? Difference types of stages?
Enlist various types of routines in datastage.
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?