Interested to Buy Any Domain ? << Click Here >> for more details...
3.What is fact less fact ?
- 9 Answers
- 14450 Views
- Accenture, HCL, TCS, I also Faced
- E-Mail Answers
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 |
Give me a broad concept of what a data warehouse is, and what it might be used for?
How can we load the time dimension?
4.Explain Snowflkeschema ?
6 Answers EDS, HCL, IBM, iFlex, TCS,
What is metadata in context of a datawarehouse and how it is important?
How Materialized Views are linked with Oracle DataWare house?
What are snapshots? What are materialized views & where do we use them?
Explain what is the difference between stop and abort?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
4 Answers IBM, MAHINDRA, Tech Mahindra,
Can any one explain the hierarchies level data warehousing.
Explain what is the difference between olap and datawarehosue?
What is the working process for application.cfm?
Why is business intelligence (bi) important in data warehousing?
Teradata 
