sql server replication: SQL 2005

We're looking at replication for reporting - a pretty common use of
replication. We also need/want to denormalize our tables in the replicated
environment for speed purposes. My question is does Replication allow me to
denormalize, or do I have to replicate the tables and then denormalize? Or
is a better solution available?

Thanks, Andre

Create an indexed view which represents your normalized/denormalized tables.
Replicate the indexed view to a table on the subscriber.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]