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
- 5876 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
Can you explain kafka connector?
What all are the different way to run a job?
What is active and passive stage?
Explain the importance of surrogate key in data warehousing?
table actions available in oracle connector?
Which commands are used to import and export the datastage jobs?
How to convert RGB Value to Hexadecimal values in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the difference between operational data stage (ods) and data warehouse?
Define orabulk and bcp stages?
What are the types of jobs we have in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are sequencers?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
