how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

---

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  

---

Triggers,VIEW,Procedures

0 Answers   CTS,

---

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---

how CAN we remove duplicates in dataset?

2 Answers   IBM,

---

what r the sources u need to create the datastage?

1 Answers  

---

What is the difference between an operational datastage and a data warehouse?

0 Answers  

---

When we will go for Data elements?

3 Answers   TCS,

---

how to write server Routine coding?

0 Answers   Eric,

---

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  

---