Get data from olap dw back to the operational db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zorba - 31 Mar 2008 13:56 GMT

Hi

Scenario is as follows:
There is an operational data store, which holds customer related data.
In order to provide analytical view, data is fed into the data
warehouse, where statistics are calculated.
I'm wondering, if analytical data can be used back at the
operational system. Eg - after defining grouping/filtering conditions
against dimensions - I'd like to push (or pull...) list of customers
matching conditions back to operational system's table.

Is there a simple way to implement such data flow?

Signature

greetings,
marcin

Reply to this Message

MC - 09 Apr 2008 08:06 GMT

I dont quite understand the problem. You have two databases. Now, you can
update records with scripts, ssis ....

MC

> Hi
>
[quoted text clipped - 8 lines]
>
> Is there a simple way to implement such data flow?

Reply to this Message

Joe H - 10 Apr 2008 17:27 GMT

this does sound interesting. Most people forward their disperate data
sources into a data warehouse - you are wanting the data source to have a
foreign key into the DW? Why wouldn't you just improve the DW ETL to
include the missing pieces?

>I dont quite understand the problem. You have two databases. Now, you can
>update records with scripts, ssis ....
[quoted text clipped - 13 lines]
>>
>> Is there a simple way to implement such data flow?

Reply to this Message

MC - 15 Apr 2008 07:58 GMT

I *think* the point here would be that there is additional data/information
in DW that possibly doesnt exist elsewhere. Then it would make sense to read
it from DW and in som ways get it back to the source system...
But im really guessing here...

MC

> this does sound interesting. Most people forward their disperate data
> sources into a data warehouse - you are wanting the data source to have a
[quoted text clipped - 18 lines]
>>>
>>> Is there a simple way to implement such data flow?

Reply to this Message