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
- 16896 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kiran
Hai This is Kiran...
If u want to join more than one table ,u can use join,lookup
and merge also.
Join: it is used join more than one table based one key
column .it can perform 4 join as inner join,left outer
join,right join and full outer join.
Lokk-UP:it is used join more than one table,but not necesary
to join based ont he key column but it need data-type.it
give reference link and single out put link and give reject
link also.it can perform inner join and left outer jojn.
main difference: if the huge amount of the data contain in
reference table refer to join else look-up.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What are the stages in datastage?
How to perform incremental load in datastage?
How do u convert the columns to rows in datastage?
How do you import and export the datastage jobs?
What is the difference between hashfile and sequential file?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the different plug-ins stages used in your projects?
how to export or import the jobs in .ISX file
What a datastage macro?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the various kinds of containers available in datastage?
What are the different options associated with dsjob command?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the difference between in process and inter process?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
