How to reload a lookup table in a tmap after each iteration
Hi,
I'm trying to build an histtory table (tbHIST) thanks to a big table (TDR20) that contains full data for each days and a date dimension table.
The aim is too loop into the dim date table to retrieve a date that will filter the miror table (TDR20) and map it with the
target table to evaluate the input data and define whether it is a new row to add or an ins/upd.
The issue is that when a use the 'run the lookup table once' (look up table that in my case is also the target table (LKP_PREP_ENDBALANCE))
in the tmap component it's not refreshing my lookup table on the second day with the date inserted in the previous date and it's loading full day each time.
I tried to use the the (run each rows) but it's almost loading 20 rows by second because for each rows of the mirror table TOS is refreshing the lookup table fullyl which in my case it's not usefull as I need a refresh by date (iteration).
So my question is how to reload the tmap lookup table after each iteration how how to exclude the iteration from the main job
(I'm using TOS 3.1)
here is the line in the TDR20 input where I'm applying the date received by the dim_dates
AND TDR_DATE ='" + globalMap.get("row1.DATE_ORA") + "'
You're welcome 😉 About your last question, only the main job traces are displayed when executing it. If your aim is to test your child job, may be you can execute it alone or use some tLogRow components to display some flows in the console. Karine
