Answer Posted / ansari
Fact table: It contains numeric values and also contain
composite key(i.e collection of foreign key) e.g.. sales
and profit.
Dimension table: It contains character values E.g
Customer_name,Customer_city.
| Is This Answer Correct ? | 48 Yes | 79 No |
Post New Answer View All Answers
Which component has onread method and what it is used for?
Explain dimensional modelling?
How to stop a batch?
Can decision tree be implemented using SQL?
What is a data profile?
What is the difference between data warehouse and operational systems?
How to improve session performance in aggregator transformation?
Explain what is metadata reporter?
Explain the difference between view and materialized view?
Where the applications and where
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is cost benefit analysis (cba)?
Can you pass sql queries in filter transformation?
How to limit the max no of rows retrieved in the report?
Explain degenerate dimension table?
