create a cube out of OLTP system?

[cognosian]

Hi Forum,

Is it possible to create a cube out of an OLTP system without making a data warehouse (start schema) out of it.

I understand that there will be performance hits but to start with is it even possible or do we always need a warehouse for it?

Thanks in advance.

Regards,
C

 

[mfgf]

Yes, you can create a cube using data from an OLTP system. Transformer will allow you to model the data dimensionally, regardless of whether or not it is physically stored in a star schema.

Regards,

MF.