6 Replies Latest reply: Sep 18, 2013 8:30 AM by user10567328 RSS

    last extract date

    user382858
      Hi,

      i wants to set last extract date 19 hours in DAC and that is bidefault in production it should run from 19hrs back with out changing further
      chinu
        • 1. Re: last extract date
          user382858
          Hi,
          Awaiting for reply

          thanks
          • 2. Re: last extract date
            NavinKumarBolla
            Hi,

            You can use prune days for setting the delay....but if you set prune days as 1 then it will start 24 hrs back i.e., delayed by 1 day.

            Hope this helps you.........

            Thanks,
            Navin Kumar Bolla
            • 3. Re: last extract date
              user382858
              Navin Sir,

              I need 19hours only

              pls help

              thanks
              • 4. Re: last extract date
                NavinKumarBolla
                Hi Chinu,

                We don't have a concept of delaying in hours. As DAC supports atleast minimum 1 day and that too you need to set it in prune days.

                If you want further information plz go through the below link

                http://www.scribd.com/doc/9268612/Prune-Days-and-Change-Capture-in-Data-Warehouse-Application-Console-DAC

                http://download.oracle.com/docs/cd/E12102_01/books/AnyInstAdm/AnyInstAdmWinInstall43.html

                Thanks,
                Navin Kumar Bolla

                Edited by: Navin Kumar Bolla on Jul 15, 2011 2:05 AM

                Edited by: Navin Kumar Bolla on Jul 15, 2011 2:12 AM
                • 5. Re: last extract date
                  Ahsan Shah
                  The following steps should work to get LAST REFRESH DATE less than 24 hours. You can also reference metalink note 889803.1:

                  1) Create a new source system parameter "REFRESH_DATE" as timestamp.

                  Name: REFRESH_DATE
                  Date Type: Timestamp
                  Variable: @DAC_SOURCE_REFRESH_TIMESTAMP
                  Function: Custom format
                  Format: YYYY-MM-DD HH24:MM:SS

                  2) Modify $$LAST_EXTRACT_DATE source system parameter properties to:
                  a) Set the value to SQL
                  b) In SQL dialog choose DBCONNECTION_OLAP (or any other connection that points to Oracle database) and enter the following string :

                  to_date('@DAC_REFRESH_DATE', 'YYYY-MM-DD HH24:MI:SS') -numtodsinterval(2,'HOUR') FROM DUAL;

                  Note: The above SQL is designed to run against Oracle database.

                  c) Make it custom format YYYY-MM-DD HH24:MM:SS


                  This will ensure that Last extract date will be refresh date time minus 2 hours.
                  • 6. Re: last extract date
                    user10567328

                    We have tried this but it does not seem to be updating refresh date properly.  Any advise?