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


"Joe H" <horton.rj at gmail> wrote in message
news:OnfiZfymIHA.1368@TK2MSFTNGP02.phx.gbl...
> 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?
>
> "MC" <markoDOTculo@gmailDOTcom> wrote in message
> news:49175679-C1CD-46A6-8D13-21032629B852@microsoft.com...
>>I dont quite understand the problem. You have two databases. Now, you can
>>update records with scripts, ssis ....
>>
>>
>> MC
>>
>>
>> "zorba" <zorba128@interia.pl> wrote in message
>> news:fsqne5$au$1@nemesis.news.neostrada.pl...
>>> 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?
>>>
>>>
>>> --
>>> greetings,
>>> marcin
>>
>
>