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 |
Tell me the Top 10 features of oracle that supports datawarehousing.
Explain what is difference between query studio and report studio?
What is Bulk Insert?
Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K
6 Answers Accenture, IBM, TCS,
How to eliminate duplicate rows from flat file?
OLAP architecture?
What are Fact tables and Dimension Tables?
What is a Decision Tree Algorithm?
What is a source qualifier?
What is hash partition?
What is multi-dimensional analysis?
if you use oracle sql*loader , how do you transform data with it during loading?