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

Sqoop Targets on Hadoop

Sqoop Targets on Hadoop

Sqoop targets are valid in mappings in a Hadoop environment.
You can include a JDBC-compliant database as a Sqoop target in an Informatica mapping that runs in a Hadoop environment:
For example, you can include the following targets in a Sqoop mapping:
  • Aurora
  • Greenplum
  • IBM DB2
  • IBM DB2 for z/OS
  • Microsoft SQL Server
  • Netezza
  • Oracle
  • Teradata
  • Vertica
You can insert data. You cannot update or delete data in a target. If you configure update arguments, Sqoop ignores them.

0 COMMENTS

We’d like to hear from you!