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 a junk dimension? What is the difference between junk dimension and degenerated dimension?
How to handle multi value dimensions?
Explain the difference between dw and bi?
in general which algorithms for used?
What are the advantages of query studio compared to report studio?
Describe the differences between a data warehouse and data mart.
Explain which are the olap tools available that are supported by oracle?
What are modeling tools available in the market?
Explain the definition of normalized and denormalized view and what are the differences between them?
Ist the schema that a data warehouse system can implements.
Explain what are fact, dimension, and measure?
Explain in detail abt measure objects? And what is the use of it? How to create it?
What are the types of SCD?
what are the all possible features supported modify stage?
if you use oracle sql*loader , how do you transform data with it during loading?