Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Working with Relational Targets in a Mapping

Working with Relational Targets in a Mapping

When you add a relational target to a mapping, you can configure the following properties:
  • Reject truncated and overflow data.
    Select this option in the target instance Properties tab when you want the Integration Service to write truncated data to the reject file.
  • Update override.
    Override the default UPDATE statement using the SQL Editor in the target instance Properties tab.
  • Table name prefix.
    Specify the owner of the target tables in the target instance Properties tab.
  • Pre- and post-session SQL.
    You can enter pre-session SQL commands for a target instance in a mapping to execute commands against the target database before the Integration Service reads the source. Enter post-session SQL commands to execute commands against the target database after the Integration Service writes to the target.
  • Target table name.
    You can override the default target table name.
You cannot configure these properties in the Target Designer.


Updated July 02, 2020