When you create a Lookup transformation using a relational table as a lookup source, you can connect to the lookup source using ODBC and import the table definition as the structure for the Lookup transformation.
Use the following options with relational lookups:
Override the default SQL statement to add a WHERE clause or to query multiple tables.
Sort null data high or low, based on database support.
Perform case-sensitive comparisons based on the database support.