Friday, November 12, 2021

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