Answer Posted / kishore reddy

database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage.

What is the purpose of pivot stage and types of containers in datastage

1042

---

On which Dimension Table you implemented SCD Type in your Project

2053

---

What is the method of removing duplicates, without the remove duplicate stage?

1029

---

Distinguish between informatica & datastage. Which one would you choose and why?

1010

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2633

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3800

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5126

---

What is the difference between datastage and informatica?

1123

---

How to clean the datastage repository?

1128

---

Difference between sequential file and data set?

1209

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2814

---

how to abort the job its matain duplicates?

2576

---

Define APT_CONFIG in Datastage?

1086

---

Explain the situation where you have applied SCD in your project?

2041

---