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.

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

---

Is sql server difficult to learn?

0 Answers  

---

Which table keeps the locking information?

0 Answers  

---

What is a result set object returned by mssql_query()?

0 Answers  

---

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

---

Can you explain different types of joins?

0 Answers  

---

How to choose all records from the table?

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

How to list all field names in the result set using mssql_field_name()?

0 Answers  

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---