8 Replies Latest reply on Jun 22, 2021 7:39 AM by Santosh Gade

    Source columns not showing from PostgreSQL

    Guim Gonzalez New Member

      We have migrated a system from OracleDB to PostgreSQl. We need to create the sources again with the PostgreSQL driver inside Informatica Powercenter Designer.

       

      The connection is OK, we can see all the tables and views inside the desired schema. But when we select any of the tables, the source is created without any columns.

       

      The table in PostgreSQL has columns and data. And if we add the columns manually into the source and preview the data works well.

       

      Anyone has a clue about what might be the issue? Thanks:)