Incremental load in Talend ETL
Автор: Anand Venkatesh
Загружено: 2023-03-10
Просмотров: 6322
Описание:
What is incremental load?
During the initial data load, all records in the staging table are inserted into the base object as new records. Once the initial data load has occurred for a base object, any subsequent load processes are called incremental loads because only new or updated data is loaded into the base object.
How to perform incremental load in Talend ETL?
1. Create a context variable 'Max Date'
2. In DB Input: Get incremental date to assign to context variable.
3. tJavaRow_1: Assign incremental date to context variable.
4. DB Input: Retrive data from source In WHERE condition call the context variable..
5. DB Output: Load data to target table.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![Incremental Load In Talend 👉 Delta Load in Talend using control table [2020] talend tutorial etl](https://imager.clipsaver.ru/dzuCoodt2qQ/max.jpg)
