DB Lookup properties list

DB Lookup properties list identifies the connection parameters and other properties you define on the Database Configuration window. Required properties are labeled in bold.

Required properties

Property	Description
Key Attribute	Select a Key Attribute from the list of IN-port attributes. This attribute corresponds to the first column of the lookup table.
Value Attribute	Select the attribute to receive the value found by the lookup from the Value attribute list. The lookup value returned overwrites any existing value. Both Key Attribute and Value Attribute might refer to the same attribute of the record structure, thus allowing the overwrite of a key with its corresponding value.
Interface	Specify the method or driver you want to use to connect to the data source.
Host Name	Specify the data source. Options available on the Host Name list depend on the interface you select.
Query	Click the Query icon to create a query that retrieves information from the data source. You can use the Query window to create a simple query, or click the Query Designer icon to open the Query Designer.

Optional properties

Property	Description
User and Password	Specify an authorized database user and a password to protect the database against unauthorized access.
Default Value	Specify a Default Value to assign to the value attribute. DB Lookup uses this value when it cannot find the key value in the lookup table.
Use Key Value	Select the option to assign the key value to the value attribute instead of the default, if the lookup fails.
Lookup Empty/Null Keys	Select the option to performs a lookup for empty or NULL key values. Otherwise, the selected default method applies.
Lookup Size	Specify the estimated number of lookup records to optimize memory allocation and lookup performance.
Database	Specify the database you want to use as data source. Additionally, you must select an appropriate interface, and in some cases, specify an appropriate user ID and password.
Schema	Identifies the schema/owner you want to use as data source. The objects displayed will be restricted accordingly and new tables will be created in that schema.
Standardize Data Format	Select the option to convert incoming `DATE` and `NUMBER` information into a standard format that Sybase ETL can move between systems that support different formats. Dates are converted into a format that includes the year, month, day, hour, minute, seconds, and fraction of a second: `YYYY-MM-DD hh:mm:ss.s`. For example, 2005-12-01 16:40:59.123 Numbers are converted with a '`.`' as the decimal separator.
Database Options	Click the Database Options icon to set options that override performance defaults and control the behavior of some transactions. See “Database connection settings”.