Answer Posted / azhar
DDL for SSAS Data bases
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create diff. Types of templates?
What are fact, dimension, and measure?
What is meant by metadata in context of a data warehouse and how it is important?
What are the differences between datamart vs. Reporting cube?
Explain piconet?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
How many types of facts and what are they?
Explain why fact table is in normal form?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain which are the olap tools available that are supported by oracle?
Is union transormation is active transformation?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is a data profile?
How to design file watch jobs?
