how to do pergformence tuning in datastage?
Answer Posted / raji
1.Avoid using transformer stage for renaming some
columns.Because it will slow down the performance of the
jobs.. Try to use Copy stage for renaming the columns.
2.Take only the required columns during the table level
lookups. Remove all the unnessary columns
3.By using partioning technique. It depends on our
requirement. It will increase the performance as well
| Is This Answer Correct ? | 29 Yes | 4 No |
Post New Answer View All Answers
Define Data Stage?
Lookup constraints
How to read multiple files using a single datastage job if files have the same metadata?
Enlist various types of routines in datastage.
How to convert RGB Value to Hexadecimal values in datastage?
Explain ibm infosphere information server and highlight its main features?
whom do you report?
What are the benefits of datastage?
What are the various kinds of containers available in datastage?
How can you write parallel routines in datastage PX?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is aggtorec restructure operator?
How to reverse the string using SQL?
What are the steps required to kill the job in Datastage?
What are some prerequisites for datastage?