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
- 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.
The Result of ETL Transformation - List of Customers
The Result of ETL Transformation - List of Orders
Feel free to try Advanced ETL Processor today. All our ETL tools have no limitations, which means you can load your data today and solve all the data quality problems right now.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL Forum