Answer / 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.

what are macros?what are its advantages and disadvantages in c language?

2 Answers  

---

True /False 1.the new operator creats a single instance named class and returns a reference to that object. 2. The conditional operator is otherwise known as the ternary operator. 3. Java compiler .Class files in the path specified in CLASSPATH environmental variable.

2 Answers   TCS,

---

hi,i just want to know the best institute to learn oracle in bangalore because i am doing my BE there?

0 Answers  

---

What is difference between ext2 and ext3 in linux

1 Answers   NetMagic,

---

my first question in huawei was ....1)Tell me about your self 2) oops concept 3)logic gates 4)ram and rom ,what is cache memory nd where it is located 5)diffrence between file system and data base 6) procedure of operating system 7)what is c# 8)high level language and machine language 9) and from mobile networkin !!!! hope thz will help you

0 Answers   Huawei,

---

What do you like and dislike about working for this organisation?

0 Answers   Microsoft,

---

One herd of camels was seen in the forest, twice the square root of the herd had gone to mountains and the remaining 15 camels were seen on the bank of a river. Find the total number of camels.

1 Answers  

---

Which one is more efficient in terms of required memory space call-by-value or call-by-referance?

0 Answers  

---

what is the Relationship between quantity of Gas and capacity of AC machine in tonnage.

0 Answers   Zee,

---

sir, plz send me the question regarding DMS gr1 questions of previous year as my exam is on 27/09/08...thanking u in advance...

0 Answers  

---

What is the difference between tcp/ip protocol and IP protocol?

0 Answers   Microsoft,

---

I am about to face the interview panel of Indian army for UES(for more details put this address http://www.freshershome.com/jobs/index.php?post_id=15715) This is basically a post for engineering job in Indian army? This is an on campus interview. Kindly help me out with some tips or the type of questions I am about to face. Thanks.

5 Answers   Indian Army, Indian Military Services, Infosys, Military Engineer Services, UES,

---