DSXchange

can anybody tell how to compare two CSV files using datastage components i need job design for the same

Define 'compare'.

- Row by row
- Size
- by Key
- any other method

where is this somparison option
in transformer itself?

Sainath.Srinivasan wrote:Define 'compare'.

- Row by row
- Size
- by Key
- any other method

No. I am asking you on how you want to compare.

look at the data and identify the uniquenes and compare on the key column which are present in both the files

Nagaraj wrote:look at the data and identify the uniquenes and compare on the key column which are present in both the files

I understand you want to compare data in two sequential files and determine rows that exist in one with rows in the other by comparing values in a key column or columns in each sequential file. You can do this by reading one sequential file into a hash file and then processing the second sequential file against the hash file checking the key column values.

Nagaraj wrote:look at the data and identify the uniquenes and compare on the key column which are present in both the files

I understand you want to compare data in two sequential files and determine rows that exist in one with rows in the other by comparing values in a key column or columns in each sequential file. You can do this by reading one sequential file into a hash file and then processing the second sequential file against the hash file checking the key column values.