Why We Ca Not Create An Aggregate On An ODS Object?
Ch KashifEnlightened
Power BI
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this answer should be reported.
Why We Ca Not Create An Aggregate On An ODS Object?
Ch Kashif
► Operational Data Store has very low data latency. Data moved to ODS mostly on
event based rather than time based ETL to Data Warehouse/Data Mart.
► ODS is more closer to OLTP system. We don’t normally prefer to store aggregated
data in OLTP. So it is with ODS.
► Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So
data aggregation is less important is ODS as data keeps changing.