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.