Fact Table Generating Another Fact Table

View previous topic View next topic Go down

Fact Table Generating Another Fact Table

Post  afsar_ali786 on Wed Apr 15, 2009 9:45 am

Dear All,

I have a question regarding Fact Table. That can a Fact Table with different Grain produces another Fact Table with some other Grain. for example: Transactions Fact Table producing Alerts Fact Table on basis of some Criteria stored in Some Dimension Table daily, monthly or custom wise.

Regards,

Afsar Ali.

afsar_ali786

Posts : 1
Join date : 2009-03-31

View user profile

Back to top Go down

Re: Fact Table Generating Another Fact Table

Post  BoxesAndLines on Wed Apr 15, 2009 10:21 am

Absolutely. I have an accumulating snapshot fact table that is populated from a transaction fact table. The only issue is dependency. One fact table cannot start loading until the first fact table has completed.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

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