How to split a file with Advanced ETL Processor
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
Source Data
- RECORD-TYPE=1 - Customer Details
- RECORD-TYPE=2 - Customer Orders
You can actually load a list of customers and a list of orders into two completely different databases. In this example we use Validator Object and validation function “Is Equal To” to separate data flow.
Transformation
Validator
List of Customers
List of Orders
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum