what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 144742 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kpk
all three stages are used to join database tables based on a
key column.
Lookupsate: input 1 reference any number (if oracle or DB2
only 1 reference link) one out put link and one reject link.
faster if the volume of data is less than the memory size.
if the siz is too huge then DS uses scrap files to store the
remaining datas and that hinders the performance.
Joinstage: can have any (but i think only 16 )tables can be
joined. does not use memory, look up is done on table level,
so would be better to use if the data volume is pretty
huge.dosent have any reject link. only one out put link.
Mergestage: can have any number of input link and update
link. need to have a key column. can have any number of
reject link. only one out put link.
| Is This Answer Correct ? | 25 Yes | 17 No |
Post New Answer View All Answers
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How and where you used hash file?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Describe the architecture of datastage?
Define Job control?
Where do you see different stages in the designer?
AGGREGATOR default datatype
What is the use of datastage designer?
what is use of SDR function?
what is the use of materialized view?
Describe stream connector?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How do you import and export data into datastage?
how many rows sorted in sort stage by default in server jobs
How you can fix the truncated data error in datastage?
