how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

0 Answers   JPMorgan Chase,

---

How do you reject records in a transformer?

0 Answers  

---

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

AGGREGATOR default datatype

0 Answers   CTS,

---

Differentiate between datastage and datastage tx?

0 Answers  

---

---

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

0 Answers  

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  

---

Define meta stage?

0 Answers  

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,

---

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,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,

---