source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

What all are the different way to run a job?

0 Answers  

---

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

---

Thanks to all people who are posting their comments...

1 Answers   CTS,

---

What are stage variables?

0 Answers  

---

I have 100 records how can I load at a time from the single time

1 Answers  

---

how to get the unique records on multiple columns by using sequential file stage only

3 Answers  

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

0 Answers   TCS,

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

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  

---

What is audit table?

1 Answers  

---