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
- 15503 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
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 is the use of materialized view?
How to Remove Duplicate using SQL?
Differentiate between validated and Compiled in the Datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the functionalities of link partitioner?
What are orabulk and bcp stages?
What are the difference types of stages?
What is a datastage job?
What are the job parameters?
Define oconv () and iconv () functions in datastage?
What is the project in datastage?
sed,awk,head
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
What are the types of containers and how to create them?
