Flow¶

A Flow allows you to load data from a source database to a data warehouse in either Initial or Incremental mode. The initial load must be run once when the target data warehouse is empty. The incremental load is run periodically to load all the changes which occur in the source database. To perform these operations, dedicated ETLs (Extract, Transform, Load) are provided. After populating an empty database with data (initial load), it is necessary to schedule a periodic run of ETL incremental loads in order to keep the data warehouse aligned with the sources. Initial loads are specifically designed to move very large amounts of data in a quick and optimized manner, whereas incremental loads move moderate amounts of data.