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
- 16343 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
Explain the situation where you have applied SCD in your project?
what is use of SDR function?
Difference between data warehousing and olap?
How you can fix the truncated data error in datastage?
What is the importance of the exception activity in datastage?
Describe the main features of datastage?
What are the steps required to kill the job in Datastage?
What is the difference between datastage and informatica?
Differentiate between Join, Merge and Lookup stage?
What are the job parameters?
How do you remove duplicate values in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is usage analysis in datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the project in datastage?
