Interested to Buy Any Domain ? << Click Here >> for more details...
if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
- 5 Answers
- 15458 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
How do you import and export the datastage jobs?
I have a few records just I want to store data in to targets cycling way how?
Demonstrate experience in maintaining quality process standards?
Does datastage support slowly changing dimensions ?
How complex jobs are implemented in datstage to improve performance?
State the difference between an operational datastage and a data warehouse?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the types of jobs we have in datastage?
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
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Describe routines in datastage? Enlist various types of routines.
How a source file is populated?
How to clean the datastage repository?
What are the types of views in datastage director?
