DB Lookup properties list

The DB Lookup properties list identifies the connection parameters and other properties you define on the Database Configuration window.


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 may refer to the same attribute of the record structure, thus allowing a key to be overwritten with its corresponding value.

Interface

Specify the method or driver to use to connect to the data source.

Host Name

Identify the data source. The options that appear on the Host Name list depend on the interface you select.

Query

Create a query that retrieves information from the data source. Use the Query window to create a simple query, or click the Query Designer icon to open the Query Designer. See “Query Designer”.


Optional properties

Property

Description

User and Password

Identify an authorized database user, and protect the database against unauthorized access.

Default Value

Assign a default value to the value attribute. DB Lookup uses this value when it cannot find the key value in the lookup table.

Use Key Value

Assign the key value to the value attribute instead of the default, if the lookup fails.

Lookup Empty/Null Keys

Perform 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

Identify the database to use as data source.

If you select this option, you must also select an appropriate interface, and in some cases, specify an appropriate user ID and password.

Schema

Identify the schema/owner you want to use as data source. The objects that appear are restricted accordingly and new tables are created in that schema.

Standardize Data Format

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 using a period (“.”) as the decimal separator.

Database Options

Set options that override performance defaults and control the behavior of some transactions.

See “Database connection settings”.