Hello,
I need your help to resolve an issue. I'm having two files called master and current file. both the files are delimiter files using | . Master file will have data around 18 to 20 Million. Extract file file will have around 50000 records. Every had I will get one new current file. Both the files are having same structure. I'm having 150 to 160 feilds in that file. Out of 150 feilds I will use key1 , first feild of both the files to identify record is existing or not, if existing I will have 6 other keys to compare . if 6 keys are similar of both the file we need to save that master file record in file x , if any difference in keys are found move the entire record of current to file y. That means we will compare master with current file, if any change occures we need to capture current file, if no change occures means master file.
Thanks in advance
Sayeevamsi