What is the extension of ASP.NET web pages ?
.ashx
.aspx
.apsx
.ascx
Find the odd one out?
MicroStrategies
Actuate
Siebel Analytics
Cognos DecisionStream
______ facts that cannot be summed up for any of the dimensions present in the fact table. For Example, temparature,bill number...etc
Additive facts
semi-additive facts
Non-additive facts
Fact less fact
The dimension tables in a star schema data mart that adhere to a common structure, and therefore allow queries to be executed across star schemas is called _______. (Note: For example, the Calendar dimension)
Degenerated dimension
Slowly changing dimensions
Conformed dimensions
Junk dimension
What are the types of Setup Captures in Wise Packaging?
Virtual Capture,SmartMonitor,Snapshot
Installation Monitor,Snapshot
Virtual Capture,SmartMonitor
Snapshot
Which one of the following is not a feature of a Data Warehouse
Time - Variant
Non Volatile
Integrated
Process Oriented
Data Warehouse's are highly normalized for better query perfomance
True
False
Data Marts are designed by ETL Developers to break the data into chuncks so that data retrival is easy for Business Analysts
Data Cleansing is mainly done at which phase of Data Warehouse Development
Extract
Transform
Load
None of the Above
The Facts in a Data Warehouse should always be numeric and nothing else