One of the benefits of using Advanced ETL Processor is the ability to load data into multiple targets. Below is a list of customer's orders exported from a CRM system. There are two different kinds of records

  • RECORD_TYPE=1 - Customer Details
    RECORD_TYPE=2 - Customer Orders

Advanced ETL Processor - Reader Object Showing Customer's Orders

You can actually load the list of customers and list of orders into two completely different databases. In this example, we use Validator object and validation function "Is Equal To" to separate dataflow

 Advanced ETL Processor - Splitting Files

  The Result of ETL Transformation - List of Customers

Advanced ETL Processor - List of Customers

 The Result of ETL Transformation - List of Orders

Advanced ETL Processor - Splitting Files - Customer Orders

Feel free to try Advanced ETL Processor today. All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

Direct link, no registration required.