Target Connector Save Modes

Owned by John Yanguas
Mar 31, 2024
2 min read

When configuring pipelines in EazyDI, the target connector represents the destination where data is loaded after transformation. Understanding the save modes available for the target connector is crucial for controlling how data is handled during the loading process. Here, we discuss the three primary save modes:

1. Append

The Append save mode adds new data to the existing target without modifying or removing any existing records. This mode is useful when you want to continuously add new data to the target without affecting the existing dataset. It allows for incremental loading, where new data is appended to the end of the target dataset.

 

image-20240331-030748.png

 

2. Overwrite

The Overwrite save mode replaces the existing data in the target with the new dataset. This mode is useful when you want to completely refresh the target with the latest data. It removes all existing records in the target and replaces them with the new dataset obtained from the pipeline.

 

image-20240331-030836.png

 

3. New

The New save mode generates a new file for file system targets when a pipeline is executed. Instead of modifying existing files or datasets, this mode creates a new file to store the data. You can indicate the name of the new file as seen below.

 

 

Â