if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
- 5 Answers
- 13459 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / kiran
when ever join 2 tables based on key columns if the key
column is numeric ,set modulus,if the key column is non
numeric set hash partition technique.and compare to look up
join give better performance coz join has sort operation
by default.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What is the sortmerge collector?
Whats difference betweeen operational data stage (ods) and data warehouse?
How to perform incremental load in datastage?
how to add a new records into source?
how to implement scd2 in datastage 7.5 with lookup stage
How the ipc stage work?
Which algorithm you used for your hashfile?
Difference between data warehousing and olap?
What is a ds designer?
How can you write parallel routines in datastage PX?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Why do you need stage variables?
What are the difference types of stages?
Explain datastage architecture?
Can we use target hash file as a lookup ?
