Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR
PROJECT?
- 2 Answers
- 9222 Views
- GE, I also Faced
- E-Mail Answers
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 is the different type of jobs in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Where the datastage stored his repository?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How do u convert the columns to rows in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
options available in sequence job to run,validate?
What are some prerequisites for datastage?
Which algorithm you used for your hashfile?
Can we use target hash file as a lookup ?
How to perform incremental load in datastage?
how to abort the job its matain duplicates?
What is a ds designer?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
whom do you report?
