Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 14310 Views
- TCS, I also Faced
- E-Mail Answers
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
which r the connectors used in san?
How a routine is called in datastage job?
What is ibm datastage flow designer?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are the functionalities of link partitioner and link collector?
What are the different common services in datastage?
How do u convert the columns to rows in datastage?
On which Dimension Table you implemented SCD Type in your Project
how to delete one row in target dataset
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is a datastage job?
What can we do with datastage director?
Define Merge?
EXPLAIN SCD
What are the some differences between 7.x and 8.x version of datastage?
