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?
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
