Answer Posted / aparna kanduri

File set can be stored on multiple Unix files as flat files.
file set contains discriptor file and individual raw data
files . No. of raw data files depends on configuration file.

There will be some limit like 2G limit on some file
systems . we can distribute data over nodes to prevent
overrun.
In such cases file set will be useful than sequential file.

What are the some differences between 7.x and 8.x version of datastage?

1253

---

root tree will find which is server job and which is parallel job?

1963

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3644

---

How do you reject records in a transformer?

1118

---

Difference between in process and inter process?

1223

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2289

---

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

1375

---

How do u convert the columns to rows in datastage?

1184

---

What all the types of jobs you developed?

1175

---

how can we create rank using datastage?what is the meaning of rank?

8781

---

What is the difference between datastage and informatica?

1109

---

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

1086

---

What is the project in datastage?

1106

---

What all are the different way to run a job?

1090

---

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

1081

---