Give the two types of tables involved in producing a star
schema and the type of data theyhold.
Answer Posted / monal
FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is a crs resource?
What is a system database and what is a user database? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What are the recovery models for a database? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what are the benefits of flashback feature?
What authentication modes does sql server support? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what do you understand by fine-grained auditing?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Can you redefine a table online?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA