SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-03-2008, 02:49 PM
| ||||
| ||||
 Get data from olap dw back to the operational db 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      |
|
04-09-2008, 05:06 PM
| |||
| |||
| Re: Get data from olap dw back to the operational db 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 |
|
04-10-2008, 05:14 PM
| |||
| |||
| Re: Get data from olap dw back to the operational db 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 > |
|
04-15-2008, 08:32 PM
| ||||
| ||||
| Re: Get data from olap dw back to the operational db 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 >> > > |
 |
« pk's on a fact table in a data warehouse
|
CFP: Visual Communication 2008 - submissions until 5 May »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
All times are GMT. The time now is 05:21 AM.
