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

Configuring Parameters for Sqoop Arguments in the Mapping

Configuring Parameters for Sqoop Arguments in the Mapping

In a Sqoop mapping, you can parameterize the Sqoop import and export arguments.
  1. Open the Sqoop mapping where you want to parameterize the Sqoop arguments.
  2. Click the
    Parameters
    tab, and define a parameter name and parameter value.
    For example, enter the parameter name as
    Param_splitByColumn
  3. Select the Read or Write transformation that is associated with the data object.
  4. Click the
    Advanced
    tab.
  5. Perform one of the following steps:
    • To parameterize Sqoop import arguments for the data object, click the
      Additional Sqoop Import Arguments
      text box and enter the parameter name you defined in the
      Parameters
      tab.
    • To parameterize Sqoop export arguments for the data object, click the
      Additional Sqoop Export Arguments
      text box and enter the parameter name you defined in the
      Parameters
      tab.
    Use the following format to specify the parameter name for a Sqoop import or export argument:
    --<Sqoop_argument_name> $<parameter_name>
    For example, enter
    --split-by $Param_splitByColumn


Updated September 28, 2020