WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR
PROJECT?
Answer Posted / kpk
1) Use user defined queries for extracting data from databases.
2) Use native databases stages rather than using ODBC.
3) Use sql join statement rather than using a lookup stage,
if the data is less.
4) Tune the SQL query (the select statement used to extract
the data from source)
5) use less oracle stages, less transformers and lookup
stages, if you have more number of stages, divide the job
into multiple jobs.
6) if ur using server jobs use IPC, Partitioner, collector.
7) if using parallel job then set the environmental variable
APT_DUMP_SCORE to TRUE. this will give a job report that
will show you what are all the operators inserted by
datastage (like sorting, needed or uneeded partition and
collection), so u can manually change the partition methods.
.... most of the performance tunning steps depends on the
job design.
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are stage variables and constants?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the different type of jobs in datastage?
What are the types of containers?
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 is quality stage?
Describe link sort?
Is the value of staging variable stored temporarily or permanently?
What is a ds designer?
Define orabulk and bcp stages?
How to read multiple files using a single datastage job if files have the same metadata?
What is the difference between datastage and datastage tx?
project Steps,hits, Project level HArd things,Solved methods?
How many areas for files does datastage have?
Define oconv () and iconv () functions in datastage?