Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 148599 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 are the components of datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
options available in sequence job to run,validate?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the purpose of pivot stage?
What is the difference between informatica and datastage?
how can we create rank using datastage?what is the meaning of rank?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How a server job can be converted to a parallel job?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are some prerequisites for datastage?
How a routine is called in datastage job?
CHANGE CAPTURE
Is it possible to query a hash file?
If you want to use a same piece of code in different jobs, how will you achieve this?
