DSXchange

HI,

The first and foremost thing ,I did was we got data in the form of flat files, I have 2 flat files say f1 and f2 ,read f1 names file and check if name stem (first 4 characters of name )is present in f2 names stem file flat file.I f found update sequence number else add new name stem with sequence number, increment sequence number or all records in f2 by 1. Finally we are comparing a column from one flat file with acolumn in second flat file .
Kindly give a solution to this problem

Thanks
Sunitha

You may need an hash file to store the list of values and reference it back.

Alternatively you can do in 2 jobs - one to lookup and write missing records, second to use it together with your original reference file to load the target.

A useful hashed file is SDKSequences. You can access this through the SDK key management routines (among other methods).