After you import a flat file source or target definition, you may need to add business names and configure file properties. Additionally, if the file definition changes, you might want to manually edit the definition.
You can edit source or target flat file definitions using the following definition tabs:
Edit properties such as table name, business name, and flat file properties.
Edit column information such as column names, datatypes, precision, and formats.
View the default numeric and datetime format properties in the Source Analyzer and the Target Designer. You can edit these properties for each source and target instance in a mapping in the Mapping Designer.
Metadata Extensions tab.
Extend the metadata stored in the repository by associating information with repository objects, such as flat file definitions.
If the file structure for a source definition changes significantly, you may need to reimport the file source definition.
When you update a source or target definition, the Designer propagates the changes to any mapping using that source or target. Some changes to source and target definitions can invalidate mappings. If the changes invalidate the mapping, you must validate the mapping. You can validate mappings from the Query Results or View Dependencies window or from the Repository Navigator. You can also validate multiple objects without opening them in the workspace. If you cannot validate the mapping from these locations, you must open and edit the mapping.
When you create sessions using file source, target, or lookups, you can override some properties you define in the Designer. For example, when you create a session with a file source, you can specify a source file location different from the location you use when you import the file source definition.