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
What is load manager?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Explain what is the difference between powerplay transformer and power play reports?
Explain difference between e-r modeling and dimentional modeling?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is data stream and data adaopter?
Explain which columns go to the fact table and which columns go the dimension table?
How much data hold in one universe.
Explain why fact table is in normal form?
Name a few sectors which use data warehousing?
Why is dimensional normalization not required?
What are the advantages and disadvantages of reporting directly against the database?
What needs to be done when the database is shutdown?
What is Cognos script editor?
What are the fundamental elements of the data warehouse?