PowerCenter All Products
Displays the source definition you are editing. To choose a different open source definition to edit, select it from the list.
Opens a dialog box to edit the name of the source definition and enter a business name.
Table owner in the database.
Optional description of source table. Character limit is 2,000 bytes/K, where K is the maximum number of bytes for each character in the repository code page. Enter links to business documentation.
Indicates the source or database type. If necessary, select a new database type.
The column names in the source. When editing a relational source definition, edit the column name only if the actual source column name changed.
The datatypes that display in the source definition depend on the source type of the source definition.
Precision and Scale
Precisionis the maximum number of significant digits for numeric datatypes, or the maximum number of characters for string datatypes. Precision includes scale.
Scaleis the maximum number of digits after the decimal point for numeric values. Therefore, the value 11.47 has a precision of 4 and a scale of 2. The string
Informaticahas a precision (or length) of 11.
All datatypes for relational sources have a maximum precision. For example, the Integer datatype has a maximum precision of 10 digits. Some numeric datatypes have a similar limit on the scale or do not allow you to set the scale beyond 0. Integers, for example, have a scale of 0, since by definition they never include decimal values.
You can change the precision and scale for some datatypes to values that differ from the values defined in the database. However, changing the precision or scale can cause numeric overflow on numeric columns, truncation on character columns, or insertion of zeroes on datetime columns when the Integration Service reads from the source column.
Choose whether you want to allow null data in the source.
Select Primary, Foreign, Primary-Foreign, or Not a Key. Applies to relational sources only.
Optionally, you can add business names to each source column.