Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 14312 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 iconv and oconv?
What are stage variables?
Define Routines and their types?
What is usage analysis in datastage?
CHANGE CAPTURE
What is the precedence of stage variables,derivations, and constraints?
What is the use of datastage director?
How many types of sorting methods are available in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
I have a few records just I want to store data in to targets cycling way how?
How do you schedule or monitoring the job?
How to reverse the string using SQL?
Explain entity, attribute and relationship in datastage?
What are the different common services in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
