Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. What's New in Informatica Intelligent Cloud Services
  3. API Center
  4. Administrator
  5. Application Integration
  6. Business 360 Console
  7. Cloud Data Integration for PowerCenter (CDI-PC)
  8. Data Access Management
  9. Data Governance and Catalog
  10. Data Ingestion and Replication
  11. Data Integration
  12. Data Integration Connectors
  13. Data Quality
  14. Data Validation
  15. MDM - Customer 360 SaaS
  16. MDM - Product 360 SaaS
  17. MDM - Reference 360
  18. MDM - Supplier 360 SaaS
  19. Multidomain MDM SaaS
  20. Monitor

What's New

What's New

Changed behavior

Changed behavior

The October 2024 release of
Data Ingestion and Replication
includes the following changed behaviors.

Optimizing use of source unique indexes when no primary key exists

After the October 2024 upgrade, new application ingestion and replication tasks and database ingestion and replications tasks preferentially use the source primary key when generating Oracle target objects. If a source does not have a primary key but does have unique indexes, the job chooses the best unique index for replication in the following order of priority: 1) the unique index that has only NOT NULL columns, 2) if multiple unique indexes have only NOT NULL columns, the unique index with the least number of columns, or 3) if no source primary key or unique NOT NULL index exists, the unique index with the greatest number of columns.

0 COMMENTS

We’d like to hear from you!