Interested to Buy Any Domain ? << Click Here >> for more details...
i having source like emptable,dept table and combined
purpose using for the join stage but join stage which
partition techq will be prefored?
pls given the ans?
- 2 Answers
- 6860 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / san
When ever you want join the two files .. you need to do hash
partition using natural keys both sides. Otherwise the value
related keys will go into different partitions and while
join match will not occur properly.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Define ds designer?
What is apt_config in datastage?
What are the functionalities of link partitioner?
What is difference between symmetric multiprocessing and massive parallel processing?
How do you register plug-ins?
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 areas of application?
Is it possible to query a hash file?
Difference between data warehousing and olap?
AGGREGATOR default datatype
What are the functionalities of link collector?
Is possible to create skid in dim,fact tables?
What is the difference between odbc and drs stage?
What are the steps required to kill the job in Datastage?
What is the difference between the local container and shared container?
