Hi Guys,
I have a requirement to do Like operation between two columns in two files.
We have to do all types of like such as
inputColumn like '%Ref.Column'
inputColumn like 'Ref.column%'
'%inputCoulmn' like Ref.Column etc.
Since both the input and ref file contains large volume of data, joining and then doing the substring operation is taking much time also consuming huge amount of disk space.
So please advice me if we can use any better solution for this
Thanks,
Rakesh K
Logic for doing LIKE operation between columns in two files
Moderators: chulett, rschirm, roy