ODS is also a small DWH which will help analyst to analysis the business. It will have data for less number of days. Generally it will be around 1 month to 6 months. Like DWH here also surrogate keys will be generated, error and reject handling will be done.
Operational Data Store is used by many organizations for analysis purpose as well as for data backup and data recovery. Data Stored in ODS is usally in Normalized form as in transactonal DB's.
While in DWH data will be denormalized ODS is actually a replica of Tacnsactional database, collection two or more business functions data.
Operational Data Store is used by many organizations for analysis purpose as well as for data backup and data recovery. Data Stored in ODS is usally in Normalized form as in transactonal DB's.
While in DWH data will be denormalized ODS is actually a replica of Tacnsactional database, collection two or more business functions data.
No comments:
Post a Comment