3 Replies Latest reply: Jun 26, 2014 5:24 AM by user12052260 RSS

    Exclude updates on specific column

    user12052260

      Dear All,

       

      We have excluded a column at source table and target accordingly.

      This column having heavy number of updates, we want to exclude all those updates happens on this column.

       

      Please help ..

       

      Os : Solaris

      RDBMS: 11.2.0.3

      GG:11.2

       

      Thanks a lot in advance

      Best Regards

      Mvk

        • 1. Re: Exclude updates on specific column
          user12052260

          Hi All,

           

          Please help on this.

           

           

          Best Regards

          Mvk

          • 2. Re: Exclude updates on specific column
            Matthew.Walden.eDBA

            Hi,

             

            Its a bit tricky, because any update is going to cause the PK to go into the redo (which you can't exclude in the Extract configuration).  Therefore if you want to exclude updates to a row where no columns of interest are updated, you have to start building up that logic yourself.

             

            One way to do this is to have a filter on Extract something like this -

             

            TABLE MYSCHEMA.MYTABLE

            FILTER (ON UPDATE, @COLTEST(COL2,PRESENT,NULL)

                            OR @COLTEST(COL3,PRESENT,NULL)

                            OR @COLTEST(COL5,PRESENT,NULL)

                            OR @COLTEST(COL6,PRESENT,NULL)

             

            Then, if COL1 is your PK and COL4 is the column you want to ignore then Extract will only pull records where one of the other columns has also changed.

             

            So you have to list all of the columns that you DO want to trigger an extract for.

             

            Does that make sense?

            • 3. Re: Exclude updates on specific column
              user12052260

              Dear