Create a new Fact table from an existing Fact table

View previous topic View next topic Go down

Create a new Fact table from an existing Fact table

Post  oke10680 on Fri Sep 23, 2011 1:30 pm

New to the forum, Hello

In our case, we had Fact table A built prior to ever thinking we would need Fact table B. Fact Table B summarizes some of the same information found in Fact table A. Fact table A is refreshed daily via ETL process. The new Fact table B needs to be refreshed monthly. My question, Is it known practice, to build new Fact tables from an exisiting Fact table? If this is ok design, then when is it not good practice?

Thanks for any help
D

oke10680

Posts : 1
Join date : 2011-09-23

View user profile

Back to top Go down

Re: Create a new Fact table from an existing Fact table

Post  ngalemmo on Fri Sep 23, 2011 7:11 pm

Yes, table b would be an aggregate fact table.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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