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
Difference between data warehousing and olap?
Distinguish between informatica & datastage. Which one would you choose and why?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How will you move hashed file from one location to another location?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between passive stage and active stage?
What is the difference between in process and inter process?
What are the enhancements made in datastage 7.5 compare with 7.0?
What a datastage macro?
Explain connectivity between datastage with datasources?
Can we use target hash file as a lookup ?
What are the different kinds of views available in a datastage director?
What is data partitioning?
Have you used Unstructured data?
how to sort two columns in single job in datastage.