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
- 16656 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
How to reverse the string using unix?
What is the sortmerge collector?
How many areas for files does datastage have?
How you can fix the truncated data error in datastage?
What is the difference between odbc and drs stage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How to convert RGB Value to Hexadecimal values in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Where the datastage stored his repository?
How and where you used hash file?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How one source columns or rows to be loaded in to two different tables?
Explain how a source file is populated?
Can you highlight the main features of ibm infosphere information server?
