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
- 16681 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sadanand
HI All,
I would like to add one more point to JOIN.
To achieve full outer join the number of inputs need would
be only two.
The Primay table need to be sorted.
Memory used is very less compared to Lookup.
Regards,
Sadanand.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how many rows sorted in sort stage by default in server jobs
Name the different sorting methods in datastage.
What is the purpose of pivot stage?
What are the features of datastage flow designer?
What is a folder? Difference types of stages?
What can we do with datastage director?
How do you schedule or monitoring the job?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the primary usages of datastage tool?
How do you register plug-ins?
What is the difference between datastage and informatica?
What are the types of containers and how to create them?
Differentiate between hash file and sequential file?
Define APT_CONFIG in Datastage?
What are the types of views in datastage director?
