multiple columns need to be lookup one table

[vinodn]

Hi,

Can you please give the suggestion for the below task,

my source:(file)

month1,month2,month3,month4--columns
1,2,3,4
2,1,3,4 ---data

Lokup table:

months:
1
2
3

So my requirement is i need to check the each column from the source to lookup column and pass the record to target,

is it possible take one lookup satge and send the data to target?

[ray.wurlod]

Yes, but the Lookup stage will need four reference inputs.

[vinodn]

Thanks Ray for you suggestion,

I need to put 24 input links for lookupsatge in one of my requirement, is it any impact on performance, input data only 1000 records,

[ray.wurlod]

Who knows? Define "performance". Nothing to prevent you using more than one Lookup stage if monitoring shows that one Lookup stage with many reference inputs is a bottleneck in the job design.