why oracle is the best database for data warehousing?

Answer Posted / srinath

ORACLE fallows total 12 E.F.CODD rules.so it is a perfect
database . where as sql fallows 10 codd rules

so all most all companies r innrsted to use ORACLE

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a data warehousing?

605


How to improve session performance in aggregator transformation?

524


Explain piconet?

546


Explain normalization?

558


What is the difference between junk dimension and degenerated dimension?

554






What is degenerate dimension table?

570


What is data type of the surrogate key?

607


How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

568


What are the different ways to represent the loading of dimension tables?

509


What is factless fact tables?

634


Explain what is the difference between a primary and secondary actor in use case modeling?

658


Why should you put your data warehouse on a different system than your oltp system?

498


Explain what are conformed dimensions?

564


What are situations where snowflake schema is better than star schema when the opposite is true?

562


What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

566