What is OLAP
What is OLAP? Briefly define it.
Expert
Online Analytical Processing (or OLAP) is a Business Intelligence (or BI) reporting system. OLAP offers the user with the capability to count, average, sum and do other easy arithmetic operations on groups of data. An OLAP report has dimensions and measures. Measures are the data values to be displayed. Dimensions are characteristics of the measures. OLAP reports are termed as OLAP cubes, though these reports are not limited to three dimensions.
Explain how one source columns or the rows may be loaded within the two different tables?
Elucidate Where to keep informatica rejected data? How to remove the informatica rejected data?
Briefly explain SQL Server 2005 Business Intelligence components?
Specify the System variables?
Explain middleware applications which ease the connection of databases to Web applications?
When is a functional dependency F considers as to be minimal?
Explain what are the roles performed by the SQL?
State the use of data stage jobs?
Write a short note on the difference between embedded and dynamic SQL?
How do I take a known dollar (totalcost) such as $240.00, back out the sales taxes from the known values using the States (VA and WV) sales tax, showing the difference so that I can print an invoice, with the fields Customer name, address, city, state Subtotal, sales tax and totalcost $240.00. All
18,76,764
1922419 Asked
3,689
Active Tutors
1420929
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!