Answer Detail: RE: explain the flow of data starting with OLTP to OLA...

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions.

February 02, 2007 04:10:08	#1
Sruthi	Member Since: Visitor Total Comments: N/A
RE: explain the flow of data starting with OLTP to OLA...
The flow of data from OLTP to OLAP is as follows: 1. Staging tables 2. Dimension tables 3. Fact tables or (Fact and Summary Tables) 4. Summary Tables