3 Replies Latest reply on Aug 9, 2020 10:34 PM by Srikanth G

    IICS Database Mass Ingestion - Issue/Bug

    Varun Kumar Yella Guru

      We are loading Data from Oracle to Azure Data Lake Gen2 in Avro Format using Database Mass ingestion task. I noticed below 2 issues.

      Issue 1: when writing the data to target the columns order are not as same as in Oracle table rather it sorting in Alphabetical order.

      Issue 2: Also, new field is getting created in target as FILE_NAME at the end.

      Please guide if this is a bug in Informatica ?

       

      Oracle Sales Table:

       

      Id

      FirstName

      LastName

      SalesId

      Phone

      Email

       

       

      Azure Data Lake Gen2 Avro File: fields are sorted in Alphabetical order and new fileld(FILE_NAME) is included.

       

      Email

      FirstName

      Id

      LastName

      Phone

      SalesId

      FILE_NAME