Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. Appendix C: Function Reference

Using the CREATE strategy

Using the CREATE strategy

Use the CREATE strategy in a mapping to drop the existing Delta Lake target table, including its data, and create a new target table with all source schema columns and their data.
  1. Create a passthrough mapping with ports dynamically linked from the Read transformation to the Write transformation.
    The following image shows the linked transformations:
    The image shows the Developer tool mapping editor with a Read transformation connected to a Write transformation using the All Ports connection.
  2. Select the Write transformation and the Ports property sheet. Select the
    Columns defined by mapping flow
    option.
    The following image shows the location of the
    Mapping flow
    option in the Ports properties:
    the iamge shows the Ports property sheet with "Columns defined by Mapping flow" selected
  3. Select the Read transformation and the Data Object property sheet. Select the
    At run time, get data object columns from the data source
    option.
    The following image shows the option location in the Data Object properties:
    The image shows the Data Object properties sheet with the "At run time, get data object columns from the data source" option selected
  4. Select the Write transformation and the Advanced property sheet. For the Target Schema Strategy property, select the
    CREATE
    option.
    The following image shows the
    Target Schema Strategy
    property in the Advanced properties:
    The image shows the Advanced properties sheet with the following options selected: The Target Schema Strategy property is set to "CREATE - Create or replace table at run time;" the Update strategy property is set to "Update and Update;" the Maintain row order" option is selected.