Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR
PROJECT?
- 2 Answers
- 9097 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 are the types of views in datastage director?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the components of datastage?
Lookup constraints
What are the features of datastage flow designer?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Define meta stage?
How to implement complex jobs in data stage?
Difference between data warehousing and olap?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How a server job can be converted to a parallel job?
Explain ibm infosphere information server and highlight its main features?
How do you schedule or monitoring the job?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
