Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rojak9999
Starting Member
3 Posts |
 Posted - 2009-12-13 : 02:32:11
|
| Hi all,For datawarehouse real-time update, we normally have a trigger in the source system to update the datawarehouse whenever a new row is in / modified. This is ideally done with only a few tables in the source system that are required for real-time reporting.What happened when there is like 50 or 60 tables needed to be updated on a real-time basis, what can we do to improve the performance on the source system server? Is there any alternative method to trigger the ETL from source to data warehouse without causing too much inteference on the source server?thanks. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-12-13 : 09:54:22
|
| Does anybody do real time updates to a "warehouse"Real time is OLTP, not OLAPReporting needs to be accurate to the nth micro-second?Who are the reports for?Bigwigs?They don't need no stikin reports in the first place...ignorant sons of b...ummm never mindBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-13 : 10:24:03
|
LOL Brett.  rojak9999, seems you want to look at transactional replication |
|
|
|
|
|
|
Real-Time Push but too many tables?