Answer Posted / ashutosh g

use Row splitter as tranform stage and specified the column
name.

What is the difference between validated and compiled in the datastage?

1293

---

What is usage analysis in datastage?

1308

---

What are stage variables, derivations and constants?

1228

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1158

---

What all the types of jobs you developed?

1181

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5123

---

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

1088

---

How can one find bugs in job sequence?

1413

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1503

---

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

1382

---

How to implement complex jobs in data stage?

1112

---

What is size of a transaction and an array means in a datastage?

1315

---

What is the roundrobin collector?

1099

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538

---

What is the difference between operational data stage (ods) and data warehouse?

1243

---