Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings
  4. Sources
  5. Targets
  6. Transformations
  7. Cluster Workflows
  8. Profiles
  9. Monitoring
  10. Hierarchical Data Processing
  11. Hierarchical Data Processing Configuration
  12. Hierarchical Data Processing with Schema Changes
  13. Intelligent Structure Models
  14. Stateful Computing
  15. Connections
  16. Data Type Reference
  17. Function Reference

User Guide

User Guide

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

0 COMMENTS

We’d like to hear from you!