sql server - Way to transfer operational data to anyalystical (reporting) data -


i have 2 database table , table b, both operational tables. table , table b contains highly normalized data, foreign keys , numerical data.

i wants transfer table , table b data highly denormalized multiple tables (reporting tables) @ every 10 minutes.

there multiple operations need perform on table , table b convert reporting data joins on foreign keys , aggregation.

the both tables, operational , reporting tables in same database schema.

should use trigger (i heard bad things trigger!), scheduled job, web service or else implement this.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -