Why we can not create an aggregate on an ODS Object? - ► 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. - Business Intelligence Interview Questions and Answers

Our Services

Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!

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. ► 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.

Category	Business Intelligence Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.8) By 131 users
Added on	9/22/2014
Views	1370
Rate it!

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. ► 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. 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:-

There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.
Answer should be complete in itself.

	Related Questions	View Answer
	How do we Tune the BO Reports for Performance Improvement?	View Answer
	Explain about Auditing in BO XI R2? What is the use of it?	View Answer
	What are dashboards?	View Answer
	How do we enhance the functionality of the reports in BO?	View Answer
	Name some of the standard Business Intelligence tools in the Market?	View Answer
	What is BAS? What is the function?	View Answer
	Why an infocube has maximum of 16 dimensions?	View Answer
	What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Explain with Examples?	View Answer
	What are the various modules in Business Objects product?	View Answer
	What is OLAP in Business Intelligence?	View Answer
	What is a Universe in Business Intelligence?	View Answer
	What is Business Intelligence?	View Answer

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