⟩ What is a Table space?
A database is divided into Logical Storage Unit called table spaces. A table space is used to grouped related logical structures together.
A database is divided into Logical Storage Unit called table spaces. A table space is used to grouped related logical structures together.
Explain Why should you put your data warehouse on a different system than your OLTP system?
List down some of the real time data-warehousing tools?
What is a general purpose scheduling tool?
Explain How are the Dimension tables designed?
What is a dimension table?
What is is a Star Schema?
Explain What are slowly changing dimensions?
What are modeling tools available in the Market?
Explain Which columns go to the fact table and which columns go the dimension table?
What are the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs?