Hello,
I have a table I need to use several times for inner join lookup in tMaps.
I wanted to use the tReplicate component but it doesn't work.
I have two tMaps (eachwith an input row).  I have my lookup table tMSSqlInput.
I have linked my table to a tReplicate component and now I want to link the tReplicate to the two tMap (lookup link) but I can only do it one time. Row link doesn't want to go on the second tMap.
Can you say me how is it possible to use the same DB input as lookup up in several tMaps ???

If you use the same select SQL request several times in a job, you have to duplicate several times the same component MSSqlInput.
So, the same request will be executed several times and it's not good for the performance !!!
(Sure, you have to be sure that the result of the requests will be the same).

Do someone know a solution to execute the request only on time and to use the result several times ???