Interested to Buy Any Domain ? << Click Here >> for more details...
Give the two types of tables involved in producing a star
schema and the type of data theyhold.
- 2 Answers
- 7625 Views
- I also Faced
- E-Mail Answers
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
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is fill factor? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What is the default fill factor value? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is dcl? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is replication? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
what are the differences of where and if in SAS?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what are the benefits of flashback feature?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
