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
- 15677 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / poorna chandra
Hi this is Poorna ,
We can Improve the performance on join stage by doing
pre sorting for both left and right data based on
key .Then we can Improve the performance in join stage .
Plz correct me if any mistake in thinking .
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the different common services in datastage?
Which warehouse using in your datawarehouse
Define Job control?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
what is ds administrator used for?
Difference between in process and inter process?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between an operational datastage and a data warehouse?
CHANGE CAPTURE
Give an idea of system variables.
What are datastage sequences?
How do you import and export the datastage jobs?
what is the use of surogate key in datastage
which r the connectors used in san?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
