3 Replies Latest reply: Aug 14, 2014 5:40 AM by 2732516 RSS

    ODI 11.1.1.7.1 and OBIA 11.1.1.7

    1042875

      We are trying to run the W_INT_ORG_D senerio as an incremental load. I created a load plan and ran the senerio the first time as a Full Load, but when I run it the second time, it does not recognize that it is an incremental load, eventhough I set the startup parameter for Incremental to Y

        • 1. Re: ODI 11.1.1.7.1 and OBIA 11.1.1.7
          _Phil

          You might get a better response if you post your question in the OBIA discussion forum:

           

          Business Intelligence Applications

          • 2. Re: ODI 11.1.1.7.1 and OBIA 11.1.1.7
            Phanikanth

            Hi

             

            To load data incremental, we have two options

             

            First:

            Apply CDC and transform incremental data into target table

             

            Second:

            You can maintain control file of last execution details timestamp of ODI job and add the same timestamps with WHO columns to transfer incremental data into target table

             

            Regards,

            Phanikanth

            • 3. Re: ODI 11.1.1.7.1 and OBIA 11.1.1.7
              2732516

              Hi,

               

              First check  W_ETL_LOAD_DATES in this table do u have a record with your scenario name or table name.

               

              When you run the scenario through load plans for the first time it will go for the full load and next time it automatically the Is Increment value will be Y and this is a variable which will be evaluated based on  W_ETL_LOAD_DATES  table and committed attribute . So if u want to go for incremental load not through load plan then you manually write an update statement which will update committed =1 based on your scenario name or target table name.

               

              update w_etl_load_dates set committed = 1 where target_table_name='W_INT_ORG_D' ;

               

              Thanks,

              Suresh