Difference in the implementation of lookup and join
stages,in joining two tables?
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
Differentiate between Join, Merge and Lookup stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the different plug-ins stages used in your projects?
Why fact table is in normal form?
Explain Quality stage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
what is flow of project?
To see hidden files in LINIX?
What is data partitioning?
How complex jobs are implemented in datstage to improve performance?
What is ibm datastage?
What is a merge?
Explain the situation where you have applied SCD in your project?
What is the use of datastage director?
EXPLAIN SCD