What are the steps involved in designing a fact table?
- 1 Answers
- 968 Views
- I also Faced
- E-Mail Answers
Answer / Kamlesh Kumar Sharma
The steps involved in designing a fact table are:
1. Identify Facts: Determine the business facts that need to be measured and tracked over time.
2. Select Measures: Choose appropriate measures (aggregates) for each fact based on the business requirements.
3. Identify Dimensions: Associate each fact with relevant dimensions to provide context and allow for analysis.
4. Normalize Facts: Break down complex facts into multiple facts if necessary, ensuring they meet normalization guidelines.
5. Define Grain: Determine the smallest level of detail that the fact table will store data for each measure.
6. Define Business Key: Identify a unique identifier for each fact record within the fact table.
7. Create Fact Table Schema: Design the schema for the fact table based on the above steps.
| Is This Answer Correct ? | 0 Yes | 0 No |
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
How do you define data block size?
What is the purpose of Dataware Control?
How Materialized Views are linked with Oracle DataWare house?
How can we load the time dimension?
What is the difference between junk dimension and degenerated dimension?
What is batch processing?
Explain reference cursor?
How many repositories can we create in Informatica?
How to generate the cubes in framework manager?
Can you state some of the innovations throughout history?
Explain the difference between dw and bi?
Teradata 
