Can Data Warehouse be used as source for operational system

Source System Analysis

I need to perform Source system analysis for existing DWH. I was wondering what are things that are done in Source system analysis. Kindly help as its crucial

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

How best to handle hierarchy defined in operational system.

In one of my sql server databases I have a tables Called CostCenter and Division. A Division can have many Cost Centers. One of the Columns in the Cost Center table is a HierarchyId Datatype Called FullPath to represent the path since there is one

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

Business Logic: DWH vs. Source system

Hello everyone, We are currently implementing a Data Warehouse (consolidating data from several source systems) and we had an argument on where the business logic should reside. Simplified example: The source contains the fields

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

Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project

Hi One of my client has multiple source OLTP system (due to acquisition) which stores same type of data e.g. order, sales amount etc now they might be called by different name according to source system but they mean the same e.g. one might call is

multi ERP source system, single DW load strategy

I am faced with the following scenario and was hoping this forum could provide some guidance: My company recently went through a large ERP system conversion (in this case Oracle E Business Suite Financials). We currently have implemented a vendor

Staging Activities

What are the common staging activities that the Kimball method recognizes? Traditionally I have used staging databases to 1) Decouple from the source-to-Data Mart for restartability 2) Consolidate multiple sources and source formats into a single

Seeking Director of Data Warehouse Development for NYC Institution (Full-Time)

We are conducting a search for a full-time: Director of Financial Information Systems (Data Warehouse Development) For a Premier organization in NYC with annual revenues in excess of $1.6B. We are seeking a dynamic, seasoned professional out of

Vantage,Corel&C'ning,Akojaya Dll-Ansur & K2(sale %%%)

KEDAI SAYA ADA KOLEKSI..BARANGAN KEPERLUAN RMH .....& JUGA KEPERLUAN KAUM HAWA...(PN/CIK/ DATIN/PUN SRI ).......seperti.......... ~~PAD BERHERBA SUSEN ~~TUPPERWARE ~~KOLEKSI VANTAGE ~ KLASIK & PREMIER ~~KOLEKSI CORRELLE & CORNING WARE

How to remove System Tool 2011

System Tool 2011 removal Note: We disclaim any affiliation with the creators of System Tool 2011 rogue antivirus. Welcome to the removal guide for System Tool 2011. This is to be considered a self-help guide, and the Security Team at this site does

Proper warning system

HI, I come baring yet another suggestion. My newest suggestion is to get an official proper warning system in place. Because to me, having a few images in the personalized profile, isn't really ideal. If other forum hosts can have this, I figured we