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.

if your monitor is not started with your cpu, but start when monitor attach to another cpu then where is the problem?

2 Answers  

---

1. Design a counter which counts 0, 4, 8, 2, 6, and repeats using: 1.a using JK flip flops 1.b using T flip flops 1.c using D flip flops 2. Modify your design in question 1.a so that the circuit works according to the following function table X Y F 0 0 Clear 0 1 No Change 1 0 Parallel Loading 1 1 Count 3. Design a circuit that detects the pattern 010 in a serial input X considering: 3.a Overlapping 3.b No overlapping

0 Answers  

---

what is mc-c in in mitsui man b&w 7s60mc-c engines.

6 Answers  

---

i am a student ,i planned for industrial visit with my four friends ,so kindly suggest me a place to visit a valid I.T industry near by chennai

4 Answers   TCS,

---

I am having 5 nos. ceiling fans in my home. if i switch on all fan at full speed say 5 , so Will my meter reading be runing fast ? OR if I keep all fans on very low speed, say 1, so meter reading will runing slowly. or it does not make any difference whether low or high. reading will remain same?

0 Answers  

---

what we have to say about hobbies,strong points,weak points

0 Answers   Banking,

---

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

0 Answers   Microsoft,

---

2. Tell me about a time when you had to use your presentation skills to influence someone's opinion.

0 Answers   Strad Energy,

---

Full form of Abt Meter

2 Answers   ABB,

---

what is the command to copy the contents from one directory to other directory?

2 Answers  

---

i want to know about the scope of IT engineers in ONGC

0 Answers  

---

WHY WE USE {} AT THE STARTING OF C PROGRAM

0 Answers  

---