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 to RD using transformer?

1431

---

How to read the length of word in unix?

1382

---

What is the difference between in process and inter process?

1157

---

What are constraints and derivations?

1173

---

What is data partitioning?

1211

---

What are the various kinds of containers available in datastage?

1048

---

Define ds designer?

1285

---

How to find value from a column in a dataset?

2207

---

Can you explain engine tier in information server?

1138

---

how to add a new records into source?

2001

---

What is difference between server jobs & parallel jobs?

1041

---

Differentiate between hash file and sequential file?

1077

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1118

---

How do you import and export the datastage jobs?

1163

---

How to manage date conversion in Datastage?

1141

---