Incremental Import Data to Data Mart

<< Click to Display Table of Contents >>

Current:  Data Mart > ETL > Pull Data from Data Source 

Incremental Import Data to Data Mart

Previous pageReturn to chapter overviewNext page

Users can set update conditions,often updated by date, for example, updating the data at zero-time, or updating the data according to other reasonable rules. 

For example

Set filter condition through where in SQL statement, and receive date parameter. 

SQL With Paremeter png

For passing the parameter value in task plan, pass the date of the day to the parameter in SQL, and add the data of the day in data mart. 

Job Filer E