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.

Define orabulk and bcp stages?

690

---

How to reverse the string using unix?

2815

---

Describe the main features of datastage?

660

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

628

---

What are the types of hashed files in data stage

646

---

---

Lookup constraints

842

---

sed,awk,head

971

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

971

---

Explain Quality stage?

671

---

What are the various kinds of containers available in datastage?

569

---

What is the different type of jobs in datastage?

577

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2292

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

2736

---

What are the different layers in the information server architecture?

645

---

What are the important features of datastage?

620

---