Table of Contents

Search

  1. Preface
  2. Introduction to Data Engineering Streaming
  3. Data Engineering Streaming Administration
  4. Sources in a Streaming Mapping
  5. Targets in a Streaming Mapping
  6. Streaming Mappings
  7. Transformation in Streaming Mappings
  8. Window Transformation
  9. Appendix A: Connections
  10. Appendix B: Monitoring REST API Reference
  11. Appendix C: Sample Files

Column Projection Properties

Column Projection Properties

The following table describes the columns projection properties that you configure for complex file targets:
Property
Description
Column Name
The name of the column in the source table that contains data.
Type
The native data type of the resource.
Enable Column Projection
Indicates that you use a schema to publish the data to the target.
By default, the columns are projected as binary data type. To change the format in which the data is projected, select this option and specify the schema format.
When you create a complex file for an XML schema, select Binary as the resource format. After you create the object, enable column projection and manually select the schema format as XML.
Schema Format
The format in which you stream data to the target. Select one of the following formats:
  • XML
  • JSON
  • Avro
  • Parquet
Use Schema
Specify the XSD schema for the XML format, the sample JSON for the JSON format, or sample Avro file for the Avro format.
Column Mapping
Click
View
to see the mapping of the data object to target mapping.
Project as Hierarchical Type
Project columns as complex data type for hierarchical data.
For more information on hierarchical data, see the
Data Engineering Integration User Guide
.

0 COMMENTS

We’d like to hear from you!