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
What is the difference between orabulk and bcp stages?
Difference between data warehousing and olap?
What are the types of containers and how to create them?
Highlight the main features of datastage?
how to add a new records into source?
which r the connectors used in san?
What are the various kinds of containers available in datastage?
What is job control?
How do you schedule or monitoring the job?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the steps needed to create a simple basic datastage job?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
what is use of SDR function?
Triggers,VIEW,Procedures
EXPLAIN SCD