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
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 meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain the hierarchies level data warehousing.
Fact table is in normalized or de-normalized form?
How to know the time taken for particular report execution?
Explain what are non-additive facts?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is a real-time data warehouse?
What is the advantages data mining over traditional approaches?
In document how to create metrics?
What is the difference between junk dimension and degenerated dimension?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What are Aggregate tables?
Explain what are components of reportnet?
What is data stream and data adaopter?
