Can ODS and datamart reside on same Oracle instance but separate schema's? What are the pros and cons?

Thanks

Thank you for your response.

Our IT contractor's are of the strong opinion that they shoud be on separate instance. Few in my management are in agreement with the contractor and has caused a stalemate. My personal preference is single instance as long as it has enough CPU and storage to serve the purpose. Hoping someone will be able to guide me to a whitepaper/article/analysis in this regards whether its for or against it.

Thanks again.

Data Warehouse vs. Operational Data Store (ODS)- They are different

Data Warehouse is an 'offline' integration of data, whereas Operational Data Store is an 'online' integration of data. ODS is used, when the data at a transaction (processing as well as querying) level is dispersed across various systems, and one needs to bring it together on online basis.

For example- Let us say that you want to have a single view of customer to be used by customer service, whereby they can also update the data in that single view online basis. However, the data on the customer (OPD Records, Hospitalization records, diagnostic records, pharmaceutical purchase records..) is lying in different databases. ODS could be a good choice.

The above-said concept of ODS is an ideal one. Another option for an Operational Data Store is to be used for online queries, but the information, which it provides is not real-time, but pertaining to last End of Day. For example you have a single customer view, but it does not include the transactions which the customer has done today. For this kind of need, some times even Data Warehouse repository can also used for this purpose.
Data Warehouse vs. Data Mart in Business Intelligence

Data Warehouse is at an enterprise level repository, which is having a combination of various data marts. Data Warehouse carries all the dimensions and measures required and it ensures the integrity of same dimensions and measures across different data marts. Data mart is a limited set of dimensions and measures used for specific business theme. They are populated out of the Data-Warehouse Data Sets.

Typically an organization's business intelligence agenda starts with few data marts, before maturing to a full-blown data warehouse. However, most of the design & development concept apply equally to a Data-mart.

Please refer De-Normalized Data Warehouse/Data Mart for detailed comparison between a Data Warehouse and Data Marts.

The advantages of Data mart are:
1.   Faster access to common data utilizing technique which optimizes data for reports.
2.   Improve end user response time
3.   Improving performance
Disadvantage:
1.   Functionality
2.   Data size
3.   Scalability
4.   Data access, and consolidation

_______