10 Replies Latest reply on Jun 15, 2021 10:25 AM by Arun Kumar

    How to do a mass update to BO Table

    Arun Kumar Guru

      Hello,

       

      I am getting requirements to update certain attributes in the BO table on a monthly basis. The attributes to be updated do not remain the same every time, so we update the landing table in the backend with an update statement and execute the batch group to get the update displayed in BO. Since landing table is truncate and load and as we have many source systems, in the next subsequent update of another set of attributes, the ones which were updated in the earlier period gets wiped off. Is there an efficient way to do this? How can we directly update the BO table without going through landing, staging etc?

       

      We are using Informatica 10.4 and E360.

       

      Appreciate your help in advance.

       

      Thanks,
      Arun