I never worked on a data warehouse based on transactional data. I do want to find out what will be the difference while generating report vs working with dimentional modeling data warehouse.
Any comments suggestions are greatly appreciated.
lavinaluo (BOB member since 2005-02-14)
Strictly speaking a data warehouse is not transactional, an OLTP database or ODS (operational data store) is. Most transactional data stores I’ve worked with are highly normalized (meaning thousands of tables), so most of the work is identifying the handful of key tables that are needed for reporting and how they interrelate.
jcaparula (BOB member since 2002-08-15)
Hi,
Even though you have a relational database, you can still do reporting.
Dimensional modeling is costlier and ofcourse it shows better performance.
And when you say about Transactional data, if we create reports on this data, the reports might be slower and it would impact transaction systems performance, reports data varies rapidly if you transaction data is having updates very frequently.
There are lot of factors, by which we define reporting. That is the reason, a separate data warehouse environment would be created and then will be loaded from transaction systems.
GowthamSen 
(BOB member since 2006-08-31)