3.What is fact less fact ?
Answers were Sorted based on User's Feedback
Answer / saravanan
A fact table which is having only foreign keys.There is no
measures
Is This Answer Correct ? | 17 Yes | 1 No |
A fact table contains only the keys ie foreign keys but no
measures(numerics) is known as factless fact table.
A Fact Table having no Facts is known as Factless Fact
Table.
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / ashok
Fact less fact table is without any Numerical
measurement , only contain key value like Foreign key
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pratap gangula
There can be only two aggregate functions in a fact less fact table....count and distinct count on the foreign keys.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kammari.krishnaiah
A fact table with out contain any facts is known as fact
less fact .here fcat tables contain the numaric values but
all numarics are not fact.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ajitha
factless fact table is fact table but it contains only
referece keys no business measures and mathematical
calculations is called factless fact table
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / hari
Fact which doest not have measures and its intersection of dimesion table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudheer.r
there is no facts in the fact table.that table is called
factless fact table
Is This Answer Correct ? | 2 Yes | 10 No |
I need to set predefined condition. How I do this?
What is factless fact schema?
What is cubes?
Why is business intelligence (bi) important in data warehousing?
How Materialized Views are linked with Oracle DataWare house?
what are relationships?
0 Answers InfoAxon Technologies,
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
How to eliminate duplicate rows from flat file?
Explain what is the difference between power center & power mart?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
what are the different views that are considered when building an object-oriented software system?
0 Answers InfoAxon Technologies,
Fact table is in normalized or de-normalized form?