Answer Posted / shar

It behaves different w r t reading capability.
i.e.,
when it is reading a single file; it does sequential mode of
reading by default and when it is reading multiple files it
does parallel mode of reading by default.

And if we need to improve performance of sequential file
stage when reading a single large file then we have two
options:
1. Read from Multiple Nodes
2. No of readers per node.

1st one is applicable only when flat file is Fixed length
file and not applicable for delimited formatted files.

The latter one is applicable for delimited files by
mentioning no of nodes then it performs parallel mode of
execution by reading single file in partitions improving the
performance.

Thats it.

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2160

---

How can you write parallel routines in datastage PX?

986

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1080

---

How many types of stage?

1139

---

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

1312

---

What is the purpose of pivot stage?

1110

---

How do you remove duplicate values in datastage?

1109

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2179

---

What are system variables and sequencers in datastage

1080

---

How do you schedule or monitoring the job?

1148

---

What are stage variables and constants?

1104

---

What is use Array size in datastage

1730

---

Describe routines in datastage? Enlist various types of routines.

958

---

What are the partitioning techniques available in link partitioner?

2237

---

Is the value of staging variable stored temporarily or permanently?

942

---