Can Data Warehouse be used as source for operational system

Data Warehouse Questions

This year, were planning on creating a data warehouse and implementing an OLAP solution. From what Ive read on this site and others, I will be better off if the data warehouse is designed with a dimensional model. I have a few questions about the

Bus Matrix - Business Process -to- Source System not 1:1?

We have a number of source systems that all do the same thing- receive loan applications. The reason for multiple systems is because some are web-based, some are for B2B, and some are legacy. So, do we list three separate Business Processes on the Bus

Extracting data when there is no timestamp in the source system

Guys, what are your strategies to extract data when the source system does not have any timestamps. Is there any way to still get deltas ? Thanks

Operational Reporting : DWH vs Legacy Application on Mainframe

I'm BI Project Manager in Organization and Process department in my company (ie from the business side and not IT side ). We have implemented a DWH with dimensional modeling. It contains absolutely all the data handled by the legacy applications on

Operational Reporting

Hello Everyone, We have a Data Warehouse built on Kimabll Architecture(Business Process and Grain Driven). Which is working fine and serving the purpose for Performance Management and Analytical Reporting. All data comes from a home grown source system

Real time datawarehouse replacing operational reporting

Hi, As I was reading through articles I came across one of the advantages in real time datawarehouse that it can replace the operational reporting so there is no need for reports to go across 2 reporting DB there can be one centralised Real time DW and

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

Request of information: Italian softwarehouse for federated Data Warehouse

Hello, I work for an Italian financial Company that needs to reorganize the current reporting system (mainly based on Business Objects), which is made of many Data Warehouses and Datamarts in Oracle and SAP/BI. I'm interested in a federated solution

Defining technical requirements for a datawarehouse, an existing one at that

I have no experience doing requirements documentation for a data warehouse, and am hoping an experienced practitioner or two can provide some practical lessons from documenting a data warehouse. To add an extra twist, the data warehouse is already in

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Reputation system

hi, its would be nice if we have this good features on phbb, maybe many of you have seen how this reputation function work on other forum so i dont need to explain here, btw, its really good if we got that here, i think ps: im gonna explain it

Award system

Is there an award system if yes where is it. If no please make what you think most of big forums use an award system

New update: anti-spam system + Google +1 Widget

Important AnnouncementNew update: anti-spam system + Google +1 Widget Hello, In response to your growing demand, and to provide you with secure forums incorporating all the latest technical progress, Forumotion and his team are proud to announce