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
- 7728 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / monal
FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
How would you go about increasing the buffer cache hit ratio?
How would you determine what sessions are connected and what resources they are waiting for?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What purpose does the model database server? : sql server DBA
deleted of control file how will u recover control file?
Where would you look for errors from the database engine?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
1)how to Take Backup in sql server 2005 from Flash Drive
Which dictionary tables and/or views would you look at to diagnose a locking issue?
internal architecture
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
