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

0 Answers  

---

DataStage Scenario based Interview Questions

1 Answers  

---

What is mapping?

3 Answers  

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,

---

Nls stands for what in datastage?

0 Answers  

---

whom do you report?

0 Answers   NTT Data,

---

Enlist various types of routines in datastage.

0 Answers  

---

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

---

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

---

On which interface you will be working as a developer?

0 Answers  

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---