What is conformed fact?
Conformed dimensions are the dimensions which can be used across multiple Data Marts in combination with multiple facts tables accordingly
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What are non-additive facts ? 24.09.08
fact table typically has two types of columns: those that contain numeric facts (often called measurements), and those that are foreign keys to dimension tabl...What is conformed fact? 23.09.08
Conformed dimensions are those table that have a fixed structure. there will b no need to change the metadata of these tables and they can go along with any num...What is conformed fact? 22.09.08
Conformed dimensions are those table that have a fixed structure. there will b no need to change the metadata of these tables and they can go along with any num...Explain the situations where snowflake is better than star schema 20.09.08
A snowflake schema is a way to handle problems that do not fit within the star schema. It consists of outrigger tables which relate to dimensions rather than...What is BUS Schema? 20.09.08
BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts. In a BUS schema we would eventually have conformed dimens...What is a Fact,Dimension,Measure? 18.09.08
Fact is key performance indicator to analyze the business.Dimension is used to analyze the fact.Without dimension there is no meaning for fact....Give the two types of tables involved in producing a star schema and the type of data they hold. 24.01.07
Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables....What are conformed dimensions? 17.03.06
Conformed dimensions mean the exact same thing with every possible fact table to which they are joined Ex:Date Dimensions is connected all facts like Sales fac...What does level of Granularity of a fact table signify? 17.03.06
Granularity The first step in designing a fact table is to determine the granularity of the fact table. By granularity, we mean the lowest level of information...What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables? 17.03.06
Snapshot facts are semi-additive, while we maintain aggregated facts we go for semi-additive. EX: Average daily balance A fact table without numeric fact colu...