if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
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
Does datastage support slowly changing dimensions ?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what is 'reconsideration error' and how can i respond to this error and how to debug this
Define Job control?
How many types of sorting methods are available in datastage?
What are the difference types of stages?
What is ibm datastage?
How to read multiple files using a single datastage job if files have the same metadata?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How complex jobs are implemented in datstage to improve performance?
Can you explain players in datastage?
What are stage variables, derivations and constants?
How to implement complex jobs in data stage?
If you want to use a same piece of code in different jobs, how will you achieve this?
whom do you report?