Answer Posted / suresh

Sr Relational Modelling Multi-Dimensional Modelling
1 Relational models can be very complex with hundreds
of tables having long chains of relationship among them.
Multidimensional modeling are very simple. Each of
the dimension table has a direct relationship with the fact
table
2 Normal data modeling is quite flexible. The
Multidimensional modeling has a rigid structure
3 One of the goals of relational modeling is to
confirm to the rules of normalization. In a normalized
database each data value is stored only once.
Multidimensional modeling are radically
denormalized. The dimension tables have a high number of
repeated values in their fields.
4 Standard relational models are optimized for On
Line Transaction Processing. OLTP needs the ability to
efficiently update data. This is provided in a normalized
database that has each value stored only once.
Multidimensional modeling are optimized for On Line
Analytical Processing. OLAP needs the ability to retrieve
data efficiently. Efficient data retrieval requires a
minimum number of joins. This is provided with the simple
structure of relationship in a Multidimensional modeling,
where each dimension table is only a single join away from
the fact table.
5 SQL queries required to manipulate relational data
MDX queries required to manipulate multi-
dimensional data
6 Tables are units of relational data storage.
Cubes are units of multi-dimensional data storage.
7 Table fields of particular data type store the
actual data. Dimensions and measures stores actual data.
8 Table size is measured in number of record set.
Cube size is measured in number of Cellsets. In
this sense, MS Excel Pivot Table can accommodate 2,040,000
cellsets (8000 * 255). Considering the summary data to be
reported, this is reasonably large. Pivot Table can report
at the most 8000 different items.

376,188,88,40,16,4,-2. Find wrong term in series

4328

---

what is a pointer in c language?

1762

---

Why is not creat swap partition in my system.

1720

---

hai iam selected in po exam in allahabad bank . my interview date is 02-06-2009. so plese send me some sample question on my email. my email is nitinbikhani@yahoo.com

1890

---

WHAT IS THE DIff Between candidate key and primary key?

1794

---

Draw a pipeline configuration to carryout the following operations on the arrays of data represented by A, B, C, D, E and F. (A i represents the i th element of the array). (Ai × Bi + Ci × Di ) (Ei × Fi ) Show the content of the pipline for i = 1 to 5

2600

---

how can one get scholership based on gre score ang how much scholarship one can get, plz suggest the way one can apply and get scholarship

3223

---

Briefly describe an experience of yours that illustrates your ability to clearly articulate and explain technical issues in a nontechnical manner

2170

---

An inversion is an array of numbers is any pair (i,j) such that iA[j]. What is the average number of inversions in an array of n distinct numbers? plz GIVE ME SOLUTION

1842

---

what is the number of water, sand and cement required for moulding brick?

1338

---

W.A.P to take input of an array and display the entered no. in dos.

1961

---

discuss the conditional formatting and advanced filtering features in MS-Excel with suitable example

1796

---

how to make resume and what should I include in it?

2145

---

What is your Job Profile in IT feild.

2493

---

what is the working of tcp/ip?

1994

---