Answer / kamal

OLAP
>Online Analytical Processing (OLAP) is a popular and
powerful data analytical method.
>It explores the complex data structure and presents the
information
OLAP functionality is:
• Multidimensional -- OLAP services provide a wide
variety of possible views or a multidimensional conceptual
view of the data by supporting a dimensional aggregation
path or hierarchies and/or multiple hierarchies.
• Easy to understand -- The data mart designed for
OLAP analysis should handle any business logic and
statistical analysis that is relevant to the application
and the developer, while at the same time, keeps it easy
enough for the target user.
• Interactive -- OLAP helps the user combine business
information through comparative,. The users are allowed to
define new ad hoc calculations as part of the analysis and
can report on the data in any desired way.
• Fast -- OLAP services are usually implemented in a
multi-user client/server mode and offer consistently rapid
responses to queries, regardless of database size and
complexity.

Answer / radhakrishnan vaithilingam

Dw:historical data for related application and this is
support to decision making system.

Eg: sales manager check the total sale details for all
loaction. every location using seperate database. so we
need to merge all data in one database.

- we can use star schema or snowflake shema

OLAP : online analtical processing.

Can you explain different types of joins?

0 Answers  

---

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

0 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.

3 Answers  

---

How to convert numeric values to integers in ms sql server?

0 Answers  

---

How to assign null values to variables or columns?

0 Answers  

---

What is raid? : SQL Server Architecture

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

Explain transaction server auto commit?

0 Answers  

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---