Oracle V/s Kalido

Hello,

There is an interesting link i came across which talks about implementing warehouse using Oracle Suite V/s implementing warehouse using Kalido tool and the back end database is still Oracle.

Kalido tool will just function as a tool and will automate much of the manual stuff and would also factor in some of the ETL functionality

Here is the link and let me know your feedback

Oracle V/s Kalido

Cube V/s Data Marts

Cubes and Data marts

I am sure all you guys who have worked in warehousing practice, have at least heard these words and many of them actually have implemented these concepts...Cube and a Data mart

Recently i was having discussion with my peers in BI/warehousing pratice, on what are the differences between Cubes and Data Marts...and to my surprise..the discussion as not so productive as we digressed to diferent terms like OLAP and ROLAP...as no one was clear which way to go for a particular scenario.

So basically i am asking is two questions
1) What are the differences between a Cube and Data mart?

I've also had folks tell me that a data mart is more than just a collection of cubes. I've also had people tell me that data mart is a reporting cube, nothing more...

So what are the distinctions you understand

2) In what scenario would you choose cube over Data Mart and vice versa?

Waiting for your inputs...

--Nilesh