ETL parameters

Introduction

Parameters allow you to dynamically select the records that must be processed in the execution step of an ETL.

A Dimension is related to each of them

Use of parameters in the ETL process

A summary describing how to use parameters is provided below, based on the following ETL steps:

Steps of the ETL process	Description
Definition of the Routine	- filters the storage of extracted and transformed data
Extraction task	- limits the number of data items to be extracted from the source; - filters the data source field related to the Dimension in the data source fields definition.
Transformation of Parameter Choice type	limits the number of data items to be transformed or used to assign a fixed value to a Dimension. - deletes all records that have an invalid value in the field of the staging table related to the Dimension.
Loading	- Limits the number of data items to be deleted, added or inserted from or onto the destination. - Filters the field of the staging table related to the Dimension in insertion operations and the field of the data destination related to the Dimension in the data target fields definition in the deletion step.
Storage	- Deletes all records that have an invalid value in the field of the staging table related to the Dimension