how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

---

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,

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,

---

How can we do null handling in sequential files?

3 Answers   Reliance,

---

what is usage of datastage with materialized views

4 Answers   HP, TCS,

---

---

Define oconv () and iconv () functions in datastage?

0 Answers  

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  

---

How can we achive parallelism

1 Answers   CTS,

---

Tell me the syntax of Configuration file?

1 Answers  

---

How to reverse the string using SQL?

0 Answers   CTS,

---

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,

---

how to convert rows into columns

2 Answers   IBM,

---