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
- 15264 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
Describe the architecture of datastage?
How do you remove duplicate values in datastage?
What is the project in datastage?
Explain ibm infosphere information server and highlight its main features?
Distinguish between informatica & datastage. Which one would you choose and why?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the difference between hashfile and sequential file?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What can we do with datastage director?
What is aggtorec restructure operator?
what is the use of materialized view?
What could be a data source system?
What is the difference between orabulk and bcp stages?
What are the types of containers?
