PowerCenter
- PowerCenter 10.5.6
- All Products
Table Settings
| Description
|
---|---|
Select Table
| Name of the target definition. To change the name, click the Rename button.
|
Business Name
| Descriptive name for the target table. Edit the Business Name using the Rename button.
|
Constraints
| Not applicable to XML targets. Any entry is ignored.
|
Creation Options
| Not applicable to XML targets. Any entry is ignored.
|
Description
| Description of target 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.
|
Code Page
| Select the code page to use in the target definition.
|
Database Type
| Indicates that the target definition is an XML target.
|
Keywords
| Use keywords to organize and identify targets. Keywords might include developer names, mappings, or XML schema names.
Use keywords to perform searches in the Repository Manager.
|
Columns Settings
| Description
|
---|---|
Select Table
| Displays the target definition you are editing. To choose a different definition to edit, select one from the list of definitions you have available in the workspace.
|
Column Name
| Name of the column.
|
Datatype
| PowerCenter datatype for the column.
|
Precision
| Size of column. You can change precision for some datatypes, such as string.
|
Scale
| Maximum number of digits after the decimal point for numeric values.
|
Not Null
| Indicates if the column can have null values.
|
Key Type
| Type of key the XML Wizard generates to link the views.
|
XPath
| Path through the XML file hierarchy that locates an item.
|
Columns Settings
| Description
|
---|---|
Select Table
| Displays the source definition you are editing. To choose a different source definition to edit, select the source definition from the list.
|
Duplicate Group Row Handling
| Choose one of these options to handle processing duplicate rows in the target:
|
DTD Reference
| DTD or XML schema file name for the target XML file. The Integration Service adds the document type declaration to the XML file when you create the XML file.
|
On Commit
| The Integration Service can generate multiple XML files or append to one XML file after a commit. Use one of the following options:
|
Cache Directory
| Directory for the XML target cache files. Default is the $PMCacheDir service process variable.
|
Cache Size
| Total size in bytes for the XML target cache. Default is auto.
|