Pivotal Knowledge Base

Follow

Informatica gpload Creates a New External Table in Every Run Instead of Re-Using the Existing Table

Environment

  • Pivotal Greenplum Database (GPDB) 4.2.x
  • Operating System- All supported

Symptom

When using gpload with Informatica to load data to Pivotal Greenplum, every time that gpload is run, a new External table is created even though "REUSE_TABLES: True" is specified in the Informatica setup.

Cause

This is an issue with Informatica 9.1.

Resolution

This issue is resolved in Informatica 9.5.1. Please upgrade to this version.

Comments

Powered by Zendesk