Answer / sravanthi menam

Create schema file for all source files and take dataset to read the files and enable RCP.In output dataset give append mode

Answer / pavankumar

Using Join Stage or Merge Stage.

What is the difference between validate and compile?

1 Answers   CTS,

---

what are the different type of errors in datastage?

2 Answers   Wipro,

---

specify data stage strength?

1 Answers  

---

how to write server Routine coding?

0 Answers   Eric,

---

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

---

how to convert rows into columns

2 Answers   IBM,

---

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 the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

---

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

---

What is the use of datastage designer?

0 Answers  

---

What are data elements?

0 Answers  

---

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  

---