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 are the types of containers in datastage?

0 Answers  

---

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

3 Answers   Accenture, Wipro,

---

What are stage variables and constants?

0 Answers  

---

Define Routines and their types?

0 Answers  

---

How to add zero "0" before record in a field?

4 Answers  

---

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

---

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

15 Answers   HCL, Scope International,

---

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,

---

What is lookup table?

5 Answers  

---

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

---

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---