Difference in the implementation of lookup and join
stages,in joining two tables?
Answer Posted / anburadh
one more point to add on MERGE and LOOKUP
Merge can not allow duplicate records whereas LOOKUP will allow or can control duplicates using OPTION"MULTIPLE ROWS ON THE LINK" which is in constraint TAB.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between account and directory options ?
Name the different types of Lookups in Datastage?
Can you filter data in hashed file?
What are the some differences between 7.x and 8.x version of datastage?
how can we create rank using datastage?what is the meaning of rank?
What are the job parameters?
Highlight the main features of datastage?
What is the difference between the local container and shared container?
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
what is the use of materialized view?
Explain usage analysis in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Enlist various types of routines in datastage.
Define meta stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.