Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149264 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
How to reverse the string using SQL?
What is the flow of loading data into fact & dimensional tables?
What are the different plug-ins stages used in your projects?
Differentiate between Join, Merge and Lookup stage?
What is the process of killing a job in datastage?
What is the purpose of interprocessor stage in server jobs?
What is difference between join, merge and lookup stage?
What all the types of jobs you developed?
What is a folder? Difference types of stages?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How do you register plug-ins?
how can we create rank using datastage?what is the meaning of rank?
What are data elements?
How to RD using transformer?
Triggers,VIEW,Procedures
