cross process(data marts) ratios

View previous topic View next topic Go down

cross process(data marts) ratios

Post  KevinP on Thu Jul 05, 2012 3:45 pm

We have 8 data marts in production and we are now designing Enterprise Data Warehouse(EDW). We will now like to identify & develop second line data marts, ex. profitability dara mart created from Revenue and Cost star schemas. This useful cross process metric may be derived from multiple fact tables either from same subject area or different subject area (say Finance & Inventory).

What are the industry best practices/guidelines in accomplishing this?
- when to develop them?
- when to create physical tables vs drill across?
- where to store them - separate schema?
- ETL issues to watch

Hope you will share your experience & thoughts on this.

Thanks

KevinP

Posts : 3
Join date : 2012-07-05

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum