Answer / subhash

SRC--->SORT--->TFM--->TGT

In the Sort Stage, mention the Sort Keys and Set
CreateKeyChangeColumn to TRUE. for each 1st of Key column,
value of the KeyChange column is '1' and for the duplicate
columns, value is '0'.
In the TFM Constraints, give constraint as 'KeyChange=0' and
set '1' for 'Abort After Rows' then the job will abort for 1st
duplicate record.

what is data mapping

2 Answers  

---

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,

---

convert yyyy mm dd to dd mm yyyy?

4 Answers  

---

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

---

What is RCP

5 Answers   CGI, CTS,

---

How can you join flat file, oracle as a sources?

4 Answers   IBM,

---

What is the use of datastage director?

0 Answers  

---

how to find out number of records imported into source file?

1 Answers  

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

can explain wt is the pool for file.

1 Answers   CTS,

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---