4 Replies Latest reply on Mar 19, 2020 12:09 AM by puneeth natesha

    Hive to Oracle errors out when target column are in lower case

    Abdul Mannan Active Member

      Hi All,

       

      We are running some mappings in informatica developer and loading data from hive to oracle table.

       

      Problem:

      "ORA-00904: Invalid identifier" when target table columns are in lower case.

       

      Cause:

      In the target schema strategy, we have selected CREATE so that informatica can generate DDL by itself. Hive table names in are in lower case and when imported into informatica as physical data objects, they are still in lower case. So when we run the mapping, DDL generated has either all columns in lower case or few of them are in lowercase but it errors out when inserting the data in this table.

       

      Options selected:

      Execution Engine: Native