What are the types of containers and how to create them?

0 Answers  

---

what is mapping lookup

1 Answers  

---

Enlist various types of routines in datastage.

0 Answers  

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

what are fact tables and dimension tables? give example assuming one table.

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,

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers  

---

How do you reject records in a transformer?

0 Answers  

---

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

0 Answers  

---

what is sparse lookup?

7 Answers   IBM,

---

How to Convert the columns into rows?

2 Answers  

---