What are the possible data marts in Retail sales

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are the possible data marts in Retail sales.?

Product information,sales information

(Continued on next question...)

Other Job Interview Questions

• What are conformed dimensions?
• What is a dimension table?
• What is a Star Schema?
• What type of Indexing mechanism do we need to use for a typical datawarehouse?
• Name some of modeling tools available in the Market?
• What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
• Why Denormalization is promoted in Universe Designing?
• What are the various Reporting tools in the Market?
• What is Dimensional Modelling? Why is it important ?
• What is aggregate table and aggregate fact table ... any examples of both?
• More...