Dear All,

Please give me some advice,
I want to create my dimension & fact tables in the same database with
OLTP data (i know that some articles say that it's not recommended),
and then I replicate it so I have another database that will be read
only and use it to create OLAP Cubes. Is this scenario will slow down
the database's performance that contain OLAP data?

Thanks in advance

I suppose the Analysis Server is not on the OLTP Server.

Once OLAP cubes with molap are created, there will be no performance
depreciation. But it will affect the performance of cube processing.
Furthermore, during processing or replication, it could affect the OLTP
system critically.

Ohjoo Kwon

"Resant" <resant_v (AT) yahoo (DOT) com> wrote

Could you give me some references how to transfer data from OLTP to
OLAP except through DTS? Any other technique that's more better than
DTS?

Thx

It's about architecture not technique, so it's not the issue of DTS.

It's about whether or not you have a separate data preparation area for ETL
processes and storage of data for use in the DW or data mart. It could be so
called Staging Area or Operational Data Store. For ETL processes, you can
use SQL only, customized coding, or other commercial products including DTS.

Ohjoo Kwon

"Resant" <resant_v (AT) yahoo (DOT) com> wrote