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

How and where you used hash file?

1222

---

How can we improve performance of data stage jobs?

1067

---

What is the flow of loading data into fact & dimensional tables?

1111

---

How do you start developing a datastage project?

1160

---

Is it possible to query a hash file?

2059

---

How do y read Sequential file from job control?

16076

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2928

---

What are the types of hashed files in data stage

1146

---

How many types of hash files are there?

1233

---

Difference between server jobs & parallel jobs?

1129

---

Where do the datastage jobs get stored?

1268

---

Explain entity, attribute and relationship in datastage?

1154

---

How a source file is populated?

1111

---

Describe link sort?

1058

---

Define orabulk and bcp stages?

1172

---