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  

---

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,

---

How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  

---

what is parameterset?

4 Answers   Wipro,

---

WHAT are unix quentios in datastage

2 Answers   TCS,

---

---

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

6 Answers  

---

Differentiate between odbc and drs stage?

0 Answers  

---

How can we improve performance of data stage jobs?

0 Answers  

---

What are datastage sequences?

0 Answers  

---

Explain connectivity between datastage with datasources?

0 Answers  

---

In merge stage can we update the values?

3 Answers   TCS,

---

What are the processing stages?

0 Answers  

---