opbang

 Profile Answers by opbang 

• Oct 4th, 2006

 

Loading frequency depends on the requirement of Business Users,  It could be daily during mid night... or weekly...  Depending on the frequency...  ETL process should take care... how the updated transaction data will replace in fact tables...

Other factors How fast OLTP is updating, Data Volume,  Available time window for Extracting Data.

pradeeshkumar

 Profile Answers by pradeeshkumar 

• Aug 19th, 2010

 

The frequency of loading data is based on the needs. It may be once in a week or at every nights.