Search Interview Questions
Question: Why we can not create an aggregate on an ODS Object?
Answer: ► 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.<br><br>► ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.<br><br>► 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.
|
|||||||||||
Question: Why we can not create an aggregate on an ODS Object?
Answer: ► 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.<br><br>► ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.<br><br>► 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. Source: CoolInterview.com If you have the better answer, then send it to us. We will display your answer after the approval Rules to Post Answers in CoolInterview.com:-
|
Related Questions | ||
How do we Tune the BO Reports for Performance Improvement? |
|
|
Explain about Auditing in BO XI R2? What is the use of it? |
|
|
What are dashboards? |
|
|
How do we enhance the functionality of the reports in BO? |
|
|
Name some of the standard Business Intelligence tools in the Market? |
|
|
What is BAS? What is the function? |
|
|
Why an infocube has maximum of 16 dimensions? |
|
|
What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Explain with Examples? |
|
|
What are the various modules in Business Objects product? |
|
|
What is OLAP in Business Intelligence? |
|
|
What is a Universe in Business Intelligence? |
|
|
What is Business Intelligence? |
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Business Intelligence Interview Questions & Answers - Exam Mode / Learning Mode
India News Network |