Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings
  4. Sources
  5. Targets
  6. Transformations
  7. Data Preview
  8. Cluster Workflows
  9. Profiles
  10. Monitoring
  11. Hierarchical Data Processing
  12. Hierarchical Data Processing Configuration
  13. Hierarchical Data Processing with Schema Changes
  14. Intelligent Structure Models
  15. Stateful Computing
  16. Connections
  17. Data Type Reference
  18. 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 January 20, 2020