Scenario

There are one or more datasources that need to be extracted, transformed and loaded into a new target system.

Let's expand this simple model to include the areas where PhixFlow brings benefits 

Solution

Extraction

PhixFlow can extract data from multiple sources, we recommend for the purposes of reconciliation that data be kept initially in its raw form with the exception of a PhixFlow UID being applied to records. The latter will allow you to handle duplicate entries. This raw data will form the baseline for the imported data, telling us how many records were provided and what data was provisioned.

Extraction

Processing typically consists of:

1. Consolidation
2. Transformation
3. Enhancement and Enrichment
4. Filtering
5. Review
6. Investigation
7. Reconciliation