How many input links can you give to a Transformer stage?

6 Answers  

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

Differentiate between datastage and datastage tx?

0 Answers  

---

Define ds designer?

0 Answers  

---

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,

---

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

---

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

Give an idea of system variables.

0 Answers  

---