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 RETAIN Strategy with Pre-SQL

Using the RETAIN Strategy with Pre-SQL

Use pre-SQL with the RETAIN strategy in a mapping to retain the existing Delta Lake target table, including its data, and add columns to it.
  1. Create a passthrough mapping with ports dynamically linked from the Read transformation to the Write transformation.
  2. Select the Write transformation and the Advanced property sheet. For Target Schema Strategy, select
    Retain.
  3. Open the Advanced property sheet. Use an ALTER TABLE Pre-SQL statement to specify the columns from the source schema to add to the target table schema.
    You can choose to put the Pre-SQL query itself into the PreSQL property, or use a parameter or parameter set that contains the query. For more information about using parameterization in mappings, see the
    Informatica Developer Tool Guide
    and the
    Informatica Developer Mapping Guide
    .
    The following image shows the PreSQL property location in the Advanced properties:
    The iamge shows the Advanced properties sheet with the PreSQL property populated with the Pre-SQL query
    The following image shows the PreSQL property with a parameter as a value:
    The iamge shows the Advanced properties sheet with the PreSQL property set to a parameter