I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

---

Difference between sequential file and data set?

0 Answers  

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

---

How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

How can you write parallel routines in datastage PX?

0 Answers  

---

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---

How do you start developing a datastage project?

0 Answers  

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---