3 Replies Latest reply: Jan 17, 2013 5:39 AM by satrap RSS

    Filtering the data

    902923
      Hi ,

      can anyone help on this below requirment, ? the requirment is , there is one to many(2) replication (oracle to oracle only) , the particular source database tables having all 2 regions data (UK and NZ) , the replication should be from source to first target with only UK datas and scond target will be with NZ data. how easy method we can use to achive this, the table has the column 'region_name' . but when i use below filter command , its not filtering caps letter as region name , only its filtering as we mentioned in the filter condition , how to filter if the region name both caps (UK)are small letters(uk), ?

      TABLE SRC.ACCOUNTS,FILTER (@STRFIND (region_name, "uk") > 0);

      the same tried with where clause and Filter clause also, but its not replication region name as UK (caps), only replicating data with 'uk'.

      also advice where we have to mention the filter conditons extract side or replicat side to get better performance?

      Thanks in advance.
        • 1. Re: Filtering the data
          satrap
          Could you try with one of the following?

          TABLE SRC.ACCOUNTS,FILTER (@STRFIND (@STRUP (region_name), "UK") > 0);
          or
          TABLE SRC.ACCOUNTS,FILTER (@STRFIND (UPPER(region_name), "UK") > 0);

          The best way to do this will be to use one extract that extracts all the data. Then use two datapump extracts, one that filters the UK data and the other that filters the NZ data.
          • 2. Re: Filtering the data
            902923
            Thanks a lot Satrap, its working as expected.
            • 3. Re: Filtering the data
              satrap
              That great.

              Which one did you use by the way?

              TABLE SRC.ACCOUNTS,FILTER (@STRFIND (@STRUP (region_name), "UK") > 0);
              or
              TABLE SRC.ACCOUNTS,FILTER (@STRFIND (UPPER(region_name), "UK") > 0);