Interested to Buy Any Domain ? << Click Here >> for more details...
Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 16888 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
What are data elements?
what is the use of materialized view?
Lookup constraints
Differentiate between hash file and sequential file?
What are the types of jobs we have in datastage?
What are stage variables?
What is a folder? Difference types of stages?
What are the primary usages of datastage tool?
Explain the importance of surrogate key in data warehousing?
What are the different layers in the information server architecture?
Can we use target hash file as a lookup ?
What is the difference between server job and parallel jobs?
What is active and passive stage?
What is process model?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
