Asked the question of how do you decide whether you need to report from transactional versus the dwh as the datasource? guess that I could have predicted the answer 'it depends'. Digging a little deeper two further suggestions, if you intend to merge datasets across silo then it makes sense to migrate the transactional data to the dwh and report. Otherwise performance could also be a good motivation, guess that you wouldn't really know this until you've decided to try it, unless your server runs so hot in which case an upgrade it needed anyway. Not really the decisive answer that I was fishing for.
Other interesting things, Terra data have partnered with Oracle around a CDC product, called golden gate, it allows you to set refresh rates between transactional and dwh that could vary. Useful feature to handle datasets that need support for different reporting frequencies.
Terradata also have a nice feature to move frequently used data to faster disk built into the product.
Also I seen to be the only person at the conference without an ipad2.
No comments:
Post a Comment