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. Window Transformation
  8. Appendix A: Connections
  9. Appendix B: Monitoring REST API Reference
  10. Appendix C: Sample Files

Advanced Properties

Advanced Properties

The following table describes the advanced properties that you configure for Cassandra targets in streaming mappings:
Property
Description
Tracing level
Controls the amount of detail in the mapping log file.
Maintain Row Order
Maintain row order while writing data to the target. Select this option if the Data Integration Service should not perform any optimization that can change the row order.
When the Data Integration Service performs optimizations, it might lose the row order that was established earlier in the mapping. You can establish row order in a mapping with a sorted flat file source, a sorted relational source, or a Sorter transformation. When you configure a target to maintain row order, the Data Integration Service does not perform optimizations for the target.
Truncate Target Table
Truncates the target before loading data.
Update Mode
Defines how rows are updated in the target tables. Select from the following options:
  • Update As Update
    . Rows matching the selected update columns are updated in the target.
  • Update Else Insert
    . Rows matching the selected update columns are updated in the target. Rows that do not match are appended to the target.
postSQL
The SQL command the Data Integration Service runs against the target database after it writes to the target.
The Developer tool does not validate the SQL.
preSQL
The SQL command the Data Integration Service runs against the target database before it reads the source.
The Developer tool does not validate the SQL.