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
- 15260 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 difference between account and directory options ?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Could anyone give brief explanation bout datastage admin
What are system variables and sequencers in datastage
Explain the situation where you have applied SCD in your project?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Define Routines and their types?
What are the stages in datastage?
What are the different kinds of views available in a datastage director?
Can you explain kafka connector?
Describe the architecture of datastage?
What are the difference types of stages?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Name the different sorting methods in datastage.
