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  

---

what is main difference between change capture and change apply stages

4 Answers   IBM,

---

what is the difference between the join and look up explin me one exmple

3 Answers  

---

What is the difference between hashfile and sequential file?

0 Answers  

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

Name the command line functions to import and export the DS jobs?

0 Answers  

---

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  

---

Differentiate between datastage and datastage tx?

0 Answers  

---

What is mapping?

3 Answers  

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---

Define Data Stage?

0 Answers  

---

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

---