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 are the important features of datastage?
Highlight the main features of datastage?
What is a quality stage in datastage tool?
What is ds designer?
Explain connectivity between datastage with datasources?
How one source columns or rows to be loaded in to two different tables?
What are stage variables, derivations and constants?
What are the areas of application?
Can you explain tagbatch restructure operator?
What are constraints and derivations?
Where the datastage stored his repository?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Can you define merge?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu