Answer Posted / azhar
DDL for SSAS Data bases
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between snowflake and star schema?
Explain the hierarchies level data warehousing.
Explain what is type 2 version dimension?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What are snapshots? What are materialized views & where do we use them?
Explain what are non-additive facts in detail?
How to improve session performance in aggregator transformation?
What is the difference between a primary and secondary actor in use case modeling?
Explain what is the difference between olap and datawarehosue?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What are data validation strategies for data mart validation after loading process?
How to create diff. Types of templates?
Explain clustering algorithm?
Is there any default username & pwd for bo designer & supervisor?
Compare aggregates and data marts