Multiple lookups to one table?

[jisoo23]

Is it ok to have more than one lookup to the same table in a mapping? I'm not sure if there would be any sort of bottleneck or potential for bad data in doing so.

Thanks,
Jisoo23

 

[blom0344]

No problem. The lookup table will be cached once.
Example: I use a calendertable as lookup to translate some bizar dateformat to a real date. In some mappings this lookup is used more than 10 times.

Ties Blom
Information analyst

 

[jisoo23]

Ok good, thanks! What about in cases where the table is huge and necessitates disabled look-up cache?