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

How you can fix the truncated data error in datastage?

1884

---

how to add a new records into source?

2055

---

Have you have ever worked in unix environment and why it is useful in datastage?

1183

---

How do you generate sequence number in datastage?

1140

---

What are the repository tables in datastage?

1350

---

Define ds designer?

1328

---

What is the difference between orabulk and bcp stages?

1072

---

What is a folder? Difference types of stages?

1240

---

table actions available in oracle connector?

1656

---

How to reverse the string using SQL?

1594

---

What are the primary usages of datastage tool?

1128

---

What is a quality stage in datastage tool?

1128

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2160

---

whom do you report?

1984

---

What is the sortmerge collector?

1176

---