can we compare two CSV files in datastage?
Moderators: chulett, rschirm, roy
can we compare two CSV files in datastage?
can anybody tell how to compare two CSV files using datastage components i need job design for the same
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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.Nagaraj wrote:look at the data and identify the uniquenes and compare on the key column which are present in both the files