how to call sequential generator in datastage?

1 Answers   IBM,

---

How can u write exception handling in seq file????

2 Answers   IBM,

---

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

---

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

What are orabulk and bcp stages?

0 Answers  

---

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

---

What is the difference between datastage and datastage tx?

0 Answers  

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---

What is aggtorec restructure operator?

0 Answers  

---

How do you import and export data into datastage?

0 Answers  

---

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  

---