1 Reply Latest reply: Jun 12, 2013 2:10 AM by Pavan. RSS

    Target Table Record count in OWB Mappings


      Hi Experts,


      I am Working with OWB 11g and i have a strange scenario as mentioned below.


      I have created around 10 Dimensions and 2 Facts and it has corresponding staging tables of around 30 tables.

      Everyday I am refreshing these tables (some are incremental and some are full load) and all these tables (around 40+) are getting refreshed with the respective inserts according to the mappings build.

      Most of the tables(staging / Dimensions /Facts) are getting incremented daily.


      My Question is :

      1) Is there a way/ work around to capture the record count of all the tables by creating a mapping at a single shot??

      2) How (which audit table) to find out this kind of information in the backend so that i can make a query according to the date and see the count as per the load and inserts.


      Note: there are multiple target tables in some mappings as well.


      Kindly Guide me.


      Many Thanks,

      Pavan Kumar.