This discussion is archived
1 Reply Latest reply: Jun 12, 2013 12:10 AM by Pavan. RSS

Target Table Record count in OWB Mappings

Pavan. Newbie
Currently Being Moderated

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.