Answer Posted / 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 |
Post New Answer View All Answers
Explain why fact table is in normal form?
What are components of report studio?
What is meta data and system catalog?
How can we run the graph? What is the procedure for that?
What are the advantages and disadvantages of reporting directly against the database?
What is dimensional modelling?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is the difference between a primary and secondary actor in use case modeling?
What is Discrete and Continuous data in Data mining world?
Explain me what is vldb?
Explain what are non-additive facts in detail?
What is metadata in context of a datawarehouse?
Explain swot analysis?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is the limit to the number of sources and targets you can have in a mapping?
