adplus-dvertising
frame-decoration

Question

In star schema there is _________ relationship between fact table and dimension table

a.

M:N

b.

1:N

c.

2:N

d.

3:N

Posted under DBMS

Answer: (b).1:N

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. In star schema there is _________ relationship between fact table and dimension table

Similar Questions

Discover Related MCQs

Q. Fact constellation is also known as

Q. __________ is the bridge between data warehouse and decision support application.

Q. Which one referes to the finding of relevant and useful information from databases

Q. Preprocessing step is used in Data _______

Q. True or False : "Selection and interpretation is a data mining functionality"

Q. Which type of metadata is held in the catalog of the warehouse database system

Q. Which metadata consists of information in the enterprise that is not in classical form

Q. The number of fact table in star schema is

Q. Which one is not a Knowledge Discovery in Databases (KDD) process

Q. Total number of stages in KDD is

Q. In the data warehouse, which data have the greatest level of details stored

Q. In Transient data, after changes with the the records, the previous version of the records will be

Q. The process of upgrading the existing quality of data before it is moved into a data warehouse is known as

Q. Which one is true about a Fact Table

Q. A decision tree where the target variable takes a continuous value, usually numbers, are called

Q. Which one is a method of incremental conceptual clustering

Q. Data warehouse architecture is based on

Q. In OLAP cubes, data (measures) are categorized by

Q. Which type of database can be used for optimizing data warehousing and OLAP (online analytical processing)

Q. ODS stands for