Truncate & load data into DB at the end which has a tloop

deepsie — Sat, 16 Nov 2024 01:31:46 GMT

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

Re: Truncate & load data into DB at the end which has a tloop

Anonymous — Mon, 07 Sep 2020 03:13:55 GMT

You can use a tMysqlRow to execute a truncate statement in the beginning of job.

Regards

Shong

topic Truncate & load data into DB at the end which has a tloop in Talend Studio

Truncate & load data into DB at the end which has a tloop

Re: Truncate & load data into DB at the end which has a tloop