Give the two types of tables involved in producing a star
schema and the type of data theyhold.
- 2 Answers
- 6857 Views
- I also Faced
- E-Mail Answers
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 get actual data change values from previous transactions in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the commands used in dcl? : sql server DBA
What is transparent data encryption? : sql server DBA
how can you connect from 10g user to 11g user??
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how can you find out if a table can be redefined?
how can you schedule a job in database?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Why would you call update statistics? : sql server DBA
what is logical system in sap basis
