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
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is the difference between clustered and non-clustered index? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
internal architecture
how can you create a user-defined lock?
what is logical system in sap basis
what is the use of recording information about current session?
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
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how to restore files with rman?
what do you understand by flashback feature of oracle?
What is dcl? : sql server DBA