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


Please Help Members By Posting Answers For Below Questions

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1661


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

711


how can you record information about current session?

497


what do you understand by flashback feature of oracle?

564


what is the use of ocr?

602






What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1969


what is the use of recording information about current session?

574


how can you schedule a job in database?

603


What the different topologies in which replication can be configured? : sql server DBA

666


how does an oracle clusterware manage crs resources?

576


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1989


how to restore files with rman?

1755


what is the diffrence between core dba and apps dba?

2094


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1977


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

1339