File schemas can be inherited from activities that are adjacent to a transformation, or they can be defined directly in the transformation, as covered in this section. A schema defined directly within the transformation takes precedence over a schema defined as part of an activity. Transformations with both a source and a target schema defined within the transformation can be referenced in multiple operations.
These pages cover the various ways to create a directly schema in a transformation:
- Custom Flat Schema
A flat file schema is a simple, one-level field structure that has the same data row type throughout the text document. Custom flat schemas are created in CSV format. - Custom Hierarchical Schema
A hierarchical file schema is a complex file structure that contains multiple file row types such as header or summary rows. Custom hierarchical schemas can be created in XML or CSV format. - Sample File Schema
If you already have a file available that contains the structure of data you want to use, you can use a sample file within a transformation. - Mirrored Schemas
If you are using a schema on the source or target side of a transformation and want to copy its structure to use on the other side of the transformation, you can mirror the schema within the transformation.