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
Explain me what is vldb?
Explain difference between snow flake and star schema.
How can you communicate with web server (apache or iis) from coldfusion?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Explain some of modeling tools available in the market?
Explain normalization?
How to load the time dimension?
What is real-time datawarehousing?
What is your spectra photometer working principles?
Explain the difference between dw and bi?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What are the possible data marts in retail sales?
Explain ddl (data definition language)?
What should I have in mind when building olap solution from scratch?
Explain what does level of granularity of a fact table signify?