Answer Posted / poorna

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
12.Change Capture
13.Filter

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

Difference between data warehousing and olap?

1090

---

What is the importance of the exception activity in datastage?

1073

---

What is ds designer?

1104

---

Differentiate between Join, Merge and Lookup stage?

1092

---

Can you highlight the main features of ibm infosphere information server?

1088

---

How do you import and export the datastage jobs?

1159

---

Define Data Stage?

1092

---

Have you used Unstructured data?

1320

---

What is datastage?

1083

---

What are the areas of application?

1151

---

How a source file is populated?

1066

---

Nls stands for what in datastage?

1190

---

Can you explain players in datastage?

1199

---

how to export or import the jobs in .ISX file

1203

---

What is the process of killing a job in datastage?

1020

---