The User Source Table (UST) section specifies how to build the IDT by sourcing data from an SQL database.

The following types of SQL data extraction are supported. An IDT can be built from:

The Loader can transform fields while extracting them from the data source. It can concatenate fields, insert text and change the case of the source fields, as described below (also refer to the

Transformations

section).