What are the types of database schema? : sql server analysis services, ssas
- 1 Answers
- 1231 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shyam Ji Mishra
There are two types of database schemas in SQL Server Analysis Services (SSAS): 1) Physical Schema: Represents the underlying structure of the data sources that provide data to the cube. 2) Logical Schema: Defines the relationships between objects within the multidimensional model and organizes them into dimensions, hierarchies, and measures.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to rebuild the master database?
How to connect php with different port numbers?
What are wait types?
How do I create a trace in sql server?
Why use identity in sql server?
Can sql servers link to other servers like oracle?
What is subquery? Explain the properties of a subquery?
Explain system functions or built-in functions? What are different types of system functions?
How to remove duplicate rows from table except one?
How do I find query history in sql server?
Does view occupy space?
Explain “row_number()” in sql server with an example?
How to convert character strings into numeric values?
List out the different types of locks available in sql server?
How to provide default values to function parameters?
