When you wish to use a relational desk as a lookup supply in the lookup transformation, you need to hook up with the lookup supply utilizing a ODBC and import the desk definition because the construction for the lookup transformation. You can use the beneath choices for relational lookups:
- You can override the default sql question and write your individual custom-made sql so as to add a WHERE clause or question a number of tables.
- You can type null knowledge based mostly on the database assist.
- You can carry out case-sensitive comparability based mostly on the database assist.
Flat File lookups:
When you wish to use a flat file as a lookup supply in the lookup transformation, choose the flat file definition in the repository or import the supply while you create the transformation. When you wish to import the flat file lookup supply, the designer invokes the flat file wizard. You can use the beneath choices for flat file lookups:
- You can use oblique information as lookup sources by configuring a file record because the lookup file title.
- You can use sorted enter for the lookup.
- You can type null knowledge excessive or low.
- You can use case-sensitive string comparability with flat file lookups.
Sorted Input for Flat File Lookups:
For flat file lookup supply, you’ll be able to enhance the efficiency by sorting the flat information on the columns that are specified in the lookup situation. The situation columns in the lookup transformation should be handled as a gaggle for sorting the flat file. Sort the flat file on the situation columns for optimum efficiency.