PowerCenter
- PowerCenter 10.5
- All Products
Table Settings | Description |
---|---|
Select Table | Displays the source definition you are editing. |
Business Name | Descriptive name for the source definition. You can edit Business Name by clicking the Rename button. |
Owner Name | Not applicable for XML files. |
Description | Description of the source. 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 | Source or database type. |
Code Page | Read Only. Not applicable for XML source files. The Integration Service converts all XML source files to Unicode. |
Columns Settings | Description |
---|---|
Select Table | Source definition you are editing. |
Column Name | Name of the column. |
Datatype | PowerCenter datatypes. |
Precision | Length of the column. |
Scale | Number of decimal positions in numerical data. |
Not Null | Indicates whether the column can accept nulls. |
Key Type | Primary key, foreign key, or not a key. |
XPath | Path of the element referenced by the current column in the XML hierarchy. XPath does not display for generated primary or foreign keys. |
Business Name | User-defined descriptive name for the column. If Business Name is not visible in the window, scroll to the right to view or modify the column. |