Answer Posted / veera

HI

1. sorted the data as much as possible in sourc database

2. Remove the unwanted columns from soure DB.

3. Drop the indexes before loading the data and Recreate
after loading the data

4. not use more than 20 stages in a job

5. Reduce the Tx stage

6. Use sort stage before an Aggregator stage (in sort mode)

7. Tuned the Project tunnables in administator for better
performance

What is active and passive stage?

1410

---

What are the different common services in datastage?

1278

---

What are data elements?

1170

---

What is the sortmerge collector?

1130

---

What is size of a transaction and an array means in a datastage?

1307

---

Differentiate between odbc and drs stage?

1046

---

What are the steps needed to create a simple basic datastage job?

1229

---

Define Routines and their types?

1181

---

What are stage variables and constants?

1145

---

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?

1035

---

How many types of sorting methods are available in datastage?

1067

---

what is flow of project?

1997

---

Describe the main features of datastage?

1072

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4036

---

How do you import and export the datastage jobs?

1157

---