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 |
How to performance tune reports?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is Sequence clustering algorithm?
Where the data cube technology is used?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
Tell me what is full load & incremental or refresh load?
Suggest a good author for hyperion in data warehousing?
What is the extension of file to save template?
Compare aggregates and data marts
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
What is core dimension?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?