Need a unix script to do match two files

[techquest]

Hi,

My req is to compare two files data. Basically these files would have been a exported data from Oracle database. It will follow the table structure. Using this structure, i want to compare the column level data between these two files.
For ex;

Data of File 1

10,test1,column 3
20,test2,column 3

Data of File 2

10,test1,column 3
40,test2,column 3

It should match these two files and say data in row2 doesnt match with the file2.

Appreciate the help

[debasisdas]

Why not do all that at database level ,before experting to flat file.

[techquest]

Why not do all that at database level ,before experting to flat file.

Appreciate the reply,

I couldnt do this at the database level because each file comes from a different database. One is from oracle and other is from netezza. Is there any way to do that

[debasisdas]

I am not familar with netezza.

[amitpatel66]

Why not store the data from netezza in to some temporary table in oracle then do the comparison then transfer to flat file.

[r035198x]

You may find it easier to use an application programming language to do these comparisons. The language would need to be one that has APIs to connect to both databases.