This document presents an example workflow in Boomi DCP. This example includes a fictitious loan department that has multiple data sources. Information about customers and loans that have been made resides in a PostgreSQL database. Information about customer communications resides in a file on a server. This workflow performs the following sequence:
- Combines the information from these sources
- Performs a data query
- Filters the data
- Transforms the data
- Generates a result
- Places the result into an HDFS data store
This example uses two data sources with multiple tables and a file to create an output. The output lists the number of customer communications for every successful loan.