Explain what is difference between query studio and report studio?
Explain the main difference between inmon and kimball philosophies of data warehousing?
What is the difference between ods and oltp?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is the difference between a primary and secondary actor in use case modeling?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
How to generate the cubes in framework manager?
Suppose we want to display zero when null values coming to report how can we do that?
Can we have multiple application.cfm file in an application?
ware house management system is used?
Explain what are the mapping paramaters and maping variables?
Explain where do we use semi and non additive facts?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is Discover and Execute in XMLA?
What is the difference between aggregate table and materialized view?