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
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are sequencers?
What are routines in datastage? Enlist various types of routines.
What is staging variable?
What is orabulk stage?
Define APT_CONFIG in Datastage?
What is quality stage?
How and where you used hash file?
What are some prerequisites for datastage?
What is the difference between server job and parallel jobs?
What are orabulk and bcp stages?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the various kinds of containers available in datastage?
Why do you need stage variables?