What is a fact table?
Answer / dipti a
Fact Table is the central table which has factual information. It contains numeric information and measures.
Lets say if you need to capture sales data then centrally we can have sales table(fact table) which contains numeric information and surrounding to it, we can have dimensions table like product dimensions, date dimensions, store dimensions.
So this central fact table will contacts numeric information like Prize_of_product, Qualntity and along with same we can have dimension foreign keys like product_id, store_id, date_id and so on.
Is This Answer Correct ? | 0 Yes | 0 No |
what is indexing ? what are different types of indexes supported by oracle ?
Explain what are slowly changing dimensions?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Explain is fact table?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
How to pivot row data using informatica?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is data warehosuing hierarchy?
What is a functional dependency f said to be minimal?
How many ways we test the universe & Report?
What is a linked cube?
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.