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
- 15675 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
Enlist various types of routines in datastage.
Notification Activity
which r the connectors used in san?
What are the types of containers in datastage?
How do y read Sequential file from job control?
What is active and passive stage?
how to delete one row in target dataset
Differentiate between Join, Merge and Lookup stage?
Which warehouse using in your datawarehouse
How you can fix the truncated data error in datastage?
What are constraints and derivations?
What are the different common services in datastage?
What are the types of containers and how to create them?
what is the difference between == and eq in UNIX shell scripting?
What is the method of removing duplicates, without the remove duplicate stage?
