Answer Posted / chiranjeevi.a

To over come the limitation of sequential file,espesially
sequential file: By default reads and writes sequentially
>memory limit is up to 2GB
>conversion is needed
>sourse stores the data out side of datastage
Data file:
>parallel process
>memory is unlimited
>No conversion is needed while reading the data(its
basically in native format).
>stores data inside the repositary

How many types of stage?

1131

---

Name the different sorting methods in datastage.

989

---

How and where you used hash file?

1107

---

Describe the architecture of datastage?

949

---

Can you explain players in datastage?

1142

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1028

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1294

---

table actions available in oracle connector?

1554

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

950

---

Enlist various types of routines in datastage.

1185

---

What is orabulk stage?

991

---

Can you explain link buffering?

1104

---

Differentiate between datastage and datastage tx?

1003

---

What are the repository tables in datastage?

1256

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2096

---