Answer Posted / 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 |
Post New Answer View All Answers
What is bi?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is difference macros and prompts?
Why facts table is useful in representing the data?
What is analytical or analytic mean?
What is core dimension?
What is the purpose of Dataware Control?
What are the steps involved in creating dimensional modeling process?
Explain the hierarchies level data warehousing.
What is dimension modeling?
what is user variable in affinium campaign? and some real time examples.
What are the stages of datawarehousing?
Compare cold fusion with other programming languages?
Explain what are conformed dimensions?
What is Cognos script editor?