You can edit the following options on the Table tab of a flat file source or target definition:
Add a more descriptive name to the source or target definition.
Add a comment or link to business documentation. These display in Repository Manager for the source or target definition. Adding comments or business documentation links to a source or target is an easy way to document its purpose. You can add or modify comments to any existing source or target.
You can enter up to (2,000 bytes)/K characters in the description, where K is the maximum number of bytes a character contains in the selected repository code page. For example, if the repository code page is a Japanese code page where K=2, each description and comment field can contain up to 1,000 characters.
Track flat file targets with key words. As development and maintenance work continues, the number of targets increases. While all of these targets may appear in the same folder, they may all serve different purposes. Keywords can help you find related targets. Keywords can include developer names, mappings, or the associated schema.
Use keywords to perform searches in the Repository Manager.
Define the source or target type. Choose Flat File for flat file sources and targets.
Flat file information.
When the database type is flat file, define the flat file properties by clicking the Advanced button.
To add options to a flat file source or target definition:
To add options to a source definition, in the Source Analyzer, double-click the title bar of the source definition. To add options to a target definition, in the Target Designer, double-click the title bar of the target definition.
The Edit Tables dialog box appears.
Click the Rename button to edit the source or target name and the business name.
Choose Flat File in the Database Type field.
Click the Advanced button to edit the flat file properties.
A different dialog box appears for fixed-width and delimited files.
To add a description, type a description in the Description field.
To add keywords for target definitions, click Edit Keywords.
The Edit Keywords dialog box appears. Use the buttons to create and move keywords.