Remove duplicate records and split source data into multiple targets

In this use case we will build an orchestration to apply auto-map to map common fields between source and target elements. We will show you different ETL and Mapping scenarios. We will cover the following mapping functionalities of the Adeptia Solution:

• Applying ‘For Each’ condition to split data into multiple outputs.

• Applying ‘Lookup’ and ‘Value-Maps’ condition

• Applying ‘Duplicate Handling’ condition

• Pivoting to single record

• Joining two sources by common key

Apart from this, we will cover common scenarios