Answer Posted / raji

1.Avoid using transformer stage for renaming some
columns.Because it will slow down the performance of the
jobs.. Try to use Copy stage for renaming the columns.
2.Take only the required columns during the table level
lookups. Remove all the unnessary columns
3.By using partioning technique. It depends on our
requirement. It will increase the performance as well

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2407

---

How do you schedule or monitoring the job?

1134

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

869

---

What is ibm datastage?

919

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4140

---

Can you define merge?

1065

---

Can you explain engine tier in information server?

1063

---

what is the use of skid in reporting?

2310

---

How to convert RGB Value to Hexadecimal values in datastage?

3929

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1687

---

Why do we use link partitioner and link collector in datastage?

1078

---

What are stage variables, derivations and constants?

1166

---

How do you remove duplicate values in datastage?

1096

---

Differentiate between datastage and informatica?

1141

---

What are the different common services in datastage?

1216

---