Extract Data from Multiple Tables
In a relational database, information about a single subject can be divided between multiple tables. This allows data to be stored more efficiently.
Consider the following tables. You might need to extract data from the Orders and Customers tables:
|
|
To extract data from multiple tables, you can use the SubTables
parameter.
To extract data from multiple tables, complete the following tasks:
- Configure the Connector
- Modify the Main Template File
- Create the Sub Table Template File
- Start the Connector
NOTE: These procedures assume that you have completed the steps in Extract Data from a Single Table.