PowerCenter
- PowerCenter 10.4.0
- All Products
Table Settings | Description |
---|---|
Select Table | Displays the source definition you are editing. To choose a different open source definition to edit, select it from the list. |
Rename button | Opens a dialog box to edit the name of the source definition and enter a business name. |
Owner Name | Table owner in the database. |
Description | 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. |
Database Type | Indicates the source or database type. If necessary, select a new database type. |
Column Settings | Description |
---|---|
Column Name | The column names in the source. When editing a relational source definition, edit the column name only if the actual source column name changed. |
Datatype | The datatypes that display in the source definition depend on the source type of the source definition. |
Precision and Scale | Precision is the maximum number of significant digits for numeric datatypes, or the maximum number of characters for string datatypes. Precision includes scale. Scale is 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 Informatica has 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. |
Not Null | Choose whether you want to allow null data in the source. |
Key Type | Select Primary, Foreign, Primary-Foreign, or Not a Key. Applies to relational sources only. |
Business Name | Optionally, you can add business names to each source column. |