Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43428 Views
- MCA, Symphony, TCS, I also Faced
- E-Mail Answers
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
what is flow of project?
What are the processing stages?
CHANGE CAPTURE
Why we use surrogate key?
Describe link sort?
How do you generate sequence number in datastage?
Explain entity, attribute and relationship in datastage?
How the ipc stage work?
What are the some differences between 7.x and 8.x version of datastage?
What is the use of datastage designer?
Describe stream connector?
What is the flow of loading data into fact & dimensional tables?
What are the functionalities of link partitioner?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the benefits of datastage?
