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
Can you explain repository tables in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How many types of sorting methods are available in datastage?
what is the difference between == and eq in UNIX shell scripting?
How do u convert the columns to rows in datastage?
Define Merge?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Difference between sequential file and data set?
What are constraints and derivations?
What are data elements?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is apt_config in datastage?
Can you filter data in hashed file?
What is ibm datastage flow designer?
Why do you need stage variables?