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
- 16609 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 delete one row in target dataset
What are the features of datastage flow designer?
Is possible to create skid in dim,fact tables?
Define meta stage?
Define oconv () and iconv () functions in datastage?
How to clean the datastage repository?
How you can fix the truncated data error in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the functionalities of link partitioner?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Why we use surrogate key?
What are the types of containers?
how to add a new records into source?
What is a quality stage in datastage tool?
