DSXchange

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

I am thinking of creating a buildop stage which can do the like operation.

which can have one input and one ref. link.

Am pretty new to the build op stage...can any one advice me on doing it...




thanks in advance

Rakesh