in Web Technologies retagged by
1,450 views
1 vote
1 vote

Fact-less fact table in a data warehouse contains

  1. Only measures
  2. Only dimensions
  3. Keys and measures
  4. Only surrogate keys 
in Web Technologies retagged by
1.5k views

1 Answer

1 vote
1 vote

ans is B

factless fact table is a fact table that does not have any measures. It is essentially an intersection of dimensions (it contains nothing but dimensional keys). There are two types of factless tables: One is for capturing an event, and one is for describing conditions.

Answer:

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true