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
- 16420 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
Can you implement SCD2 using join, transformer and funnel stage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Can you explain kafka connector?
What are the processing stages?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the types of hashed files in data stage
Can you explain players in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How and where you used hash file?
Nls stands for what in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is a merge in datastage?
Describe routines in datastage? Enlist various types of routines.
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the difference between Datastage 7.5 and 7.0?
