Database sources include relational sources such as Oracle, MySQL, and Microsoft SQL Server. When you configure a Source transformation for a database source, you can use a single source table or multiple source tables. If you use multiple tables as a source, you can select related tables or create a relationship between tables.
To configure a Source transformation for a database source, perform the following tasks:
Configure the source properties.
If the source includes multiple tables, configure the Source transformation to join the tables. You can join related tables or specify a custom relationship.
Optionally, configure a custom SQL query to extract source data.
Optionally, configure the Source transformation to filter or sort source data.
Ensure that the table and column names do not exceed 74 characters.
ASK INFAPreview
