Answer / 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.

Answer / kiran

1.In drvition ,Instead of calling routines implementing
stage variales.
2.while using ODBC Stag,adjust as per row seetings.
3.using user defined queiries while Extract the date from
sorce.
4.minimize null values
5.minimize unused columns
6.minimize warninigs
7.don't use more than 7 look up in a job,if exceede take
another transformer.
8.don't use morethan 20 stages in a job.
9.before loading data drop indexes after re created indexes.
10.worked with DBA-Admin for
11.tuned in Project tunes in Datastage Admin
12
13
14
15
16

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

---

Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,

---

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,

---

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want

3 Answers  

---

what is the use of surogate key in datastage

0 Answers   TCS,

---

where we use config file as parameter ?

1 Answers   IBM,

---

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

---

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

2 Answers   Wipro,

---

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

---

How and where you used hash file?

0 Answers  

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

How to create user defined environment varibale(parameter)?

1 Answers   TCS,

---