if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
- 5 Answers
- 13482 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / professional
Hi,
For the above query to improve the performance based on key columns in emp and dept joins by default sort in datastage for better performance if you have already a sorted data just go for environmental variables and do the operation #APT_Not_SORTDATA option then performance increase automatically...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Notification Activity
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are data elements?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How to Remove Duplicate using SQL?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the importance of the exception activity in datastage?
How many Key we can define in remove duplicate stage?
How we can covert server job to a parallel job?
Can you explain kafka connector?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is ibm datastage flow designer?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
