Search code examples
informaticainformatica-powercenter

Informatica Power Center - ERROR: "Target table [TABLE_NAME] has no keys specified."

everyone, I've a problem in Informatica PowerCenter.

In my mapping I have 5 objects:

  • 1x Source Table
  • 1x Source Qualifier
  • 1x Expression Transformation
  • 1x Update Strategy
  • 1x Target Table

The source and target table have no primary key, how come Informatica PowerCenter expects a key?

Solution

  • I have tried changing the "Treat source rows as" property of my workflow session from "Insert" to "Data driven" and it is working.