Six Stars

what does "load once" mean in tMap?

In the tMap, we can set Lookup modoel to "Load once". I am wondering what this mean.
Does it mean it will load once a day? or one transaction? or something else?


Re: what does "load once" mean in tMap?

It means once during the job execution (at the very beginning of the job).
Load at each row : the lookup is loaded every time a row is processed in the main flow.
Reload at each row cache : reload it only if the current value has not been encountered yet