Answer Posted / balaji

these are mostly used in real time scenario:
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.

debugging stage are:
1.head stage
2.tail stage
3.peek stage

How and where you used hash file?

1172

---

Is possible to create skid in dim,fact tables?

2636

---

What is a merge?

1169

---

What is data partitioning?

1202

---

How will you move hashed file from one location to another location?

2151

---

What are the types of containers and how to create them?

976

---

Differentiate between Join, Merge and Lookup stage?

1092

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2228

---

How you Implemented SCD Type 1 & Type 2 in your project?

4129

---

How many Key we can define in remove duplicate stage?

1383

---

Give an idea of system variables.

1032

---

What are sequencers?

1115

---

How to clean the datastage repository?

1126

---

Difference between data warehousing and olap?

1089

---

Difference between in process and inter process?

1234

---