| |
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.
|
| March 03, 2008 04:10:34 |
#5 |
| verma_tushar |
Member Since: February 2008 Total Comments: 1 |
RE: explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions.
|
In some of the cases Pre Stage is also a intermediate phase between the OLTP environment and actual staging area.
The prestage is one where dta clensing, data profiling nad data validation takes place. In stage, on the other hand. we apply actual business logic of the ETL phase to bring baout the requiered OLAP objects.
However, both prestage and stage form ODS(Operational Data Source) together. |
| |
Back To Question | |
