Truncate & load data into DB at the end which has a tloop
Hi All,
I have a requirement in which I have to fetch the data from an API and store it in the database.
I want to implement truncate and load i.e. load the data from all pages into the DB everyday.
The API has pagination. Hence, I am using a tloop to loop through the pages until it reaches the last page. But it truncates and loads the data for every page which is not what I intended. Please help me truncate the table once before it starts loading the data of each page into the table.
My job:
tloop -- iterate-- thttprequest->extract the fields & transformations(tmap) --main-- tmysloutput
