q What is ODS?
vStands
for Operational data store
vContains
current data for a limited period of time.(DWH stores periodic data).
vShould
be refreshed daily to get current data(daily or hourly)
vUse
to monitor the business.
vSits
between Staging and DWH
q What is Staging Area?
vParking
area used to dump and integrate data
from heterogeneous source systems
vUse to cleanse data,
apply multiple business rules, filter it and then push it to your Data
Warehouse /ODS
No comments:
Post a Comment