When you configure a session, you can configure lookup properties that are unique to sessions:
Flat file lookups.
Configure lookup location information, such as the source file directory, file name, and the file type.
You can define $Source and $Target variables in the session properties. You can also override connection information to use the $DBConnection
. Configure the lookup source file properties such as the source file directory, file name, and the file type. If the source is a relational table or application source, configure the connection information.