Table of Contents


  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Connections
  4. Mappings in a Hadoop Environment
  5. Mappings in the Native Environment
  6. Profiles
  7. Native Environment Optimization
  9. Data Type Reference

Relational Sources

Relational Sources

Relational sources are valid in mappings in a Hadoop environment with certain restrictions
The Data Integration Service does not run pre-mapping SQL commands or post-mapping SQL commands against relational sources. You cannot validate and run a mapping with PreSQL or PostSQL properties for a relational source in a Hadoop environment.
The Data Integration Service can use multiple partitions to read from the following relational sources:
  • IBM DB2
  • Oracle
You do not have to set maximum parallelism for the Data Integration Service to use multiple partitions in the Hadoop environment.

Updated July 03, 2018