Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 14268 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
How do you remove duplicate values in datastage?
What is usage analysis in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Define Routines and their types?
project Steps,hits, Project level HArd things,Solved methods?
How to find value from a column in a dataset?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Difference between in process and inter process?
How do you schedule or monitoring the job?
How to Remove Duplicate using SQL?
Notification Activity
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is ds designer?
On which Dimension Table you implemented SCD Type in your Project
How do you run datastage job from the command line?
