Give the two types of tables involved in producing a star
schema and the type of data theyhold.
Answer Posted / jeshani
Fact tables and dimension tables.
A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can you create a user-defined lock?
what do you understand by flashback feature of oracle?
What is dcl? : sql server DBA
what is a user-defined lock?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
how can you find out if a table can be redefined?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is a correlated sub-query? : sql server DBA
What are the recovery models for a database? : sql server DBA
when does an alert gets signaled?
What purpose does the model database server? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
how can you schedule a job in database?