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 is gr1 card in dg battery charger?

1 Answers   INDUS,

---

A number when divided by D leaves a remainder of 8 and when divided by 3D leaves a remainder of 21 . What is the remainder left, when twice the number is divided by 3D?

2 Answers   TCS,

---

No. of rounds: 1. GD 2. Written test 3. Technical round 4. HR Group Discussion: In GD I got topic “Effect of Movies on Youth, is it good or bad?”. Everyone got chance to speak. They examined the fluency and point of view on topic. I was selected in this round. Written Test: In written, there were 30 to 40 question including 5 subjective, they are, 1 What is RTTI(Run Time Type Information)? 2 What is containership? 3 What is the difference between compiler level of C++, C# and one other language? 4 Why C++ reserve 2 bytes for structure? 5 One question was related to dot net….. Remaining question are objective and they are belongs to C, Data Structure, 4-5 question from Java and also some questions from Software Development, includes, Some programs given with there output, questions related to sorting algorithm and there complexities, from java, multithreading and a program for Concatenation of two strings using inbuilt methods, from Software development they ask about software lifecycle(including all phases), specification and testing. It was all technical and I cleared the written too. Technical round: In this round, they asked about my resume. Remember the things that you write only those things in resume, in which you are very well, else it will create problems for you. They asked first about myself, and then about my programming skills. They give me a problem to solve in C. They ask me about SQL commands (because I mentioned in resume) like difference between delete and truncate, left join with syntax, then some questions from OS and computer network. I also found out that they were taking my stress testing. They fired questions very rapidly. Don’t give up they will make you feel free environment if you will get nervous (at that time I was). HR round: In this round as usual they asked about personal question to starting with about yourself. They asked some IQ questions like which object with four points are at equidistance, draw three co-centric circle without pull-up your hand, they also asked question, if a bear is jump from 1 meter in …sec. what is the color of that bear. Answer is related to measuring gravity according to south and north pole, and I was confused at that time. They also asked the meaning of my name, I gave that answer.

0 Answers   Consagous,

---

Write a program in ‘C’ that will accept 10 numbers from the user, sort them & then perform the binary search. The searching number will be arithmetic mean of the 10 numbers accepted from the user. Write the sort() & binSearch() functions for performing the sorting & binary search. Also create display function() for displaying the list. Sort() function will use selection sort and only receive one argument (Single char type)as type of sorting i.e. ascending (a) or descending (d). Display the list after sorting using a display() function. binSearch() function will accept one argument as a number to be search & return null or the index position of that number in the array. display() function is non argument non return type function. It will simply display the list row-wise. Program should use these functions by displaying the appropriate message for found or not found.

0 Answers  

---

why you are suitable to work here???? plzz give me the ans f this Q. i was told to write 200 words on the spot....

0 Answers  

---

What is the dewpoint of atmoshperic Air?

0 Answers  

---

I am some what lagging in talking English but i love to do job as an software engineer what will i do to improve my communication skills? please give me answer..........

1 Answers  

---

why pegging is required for deaerator in power plant nd why maintain the constant pressure in deaerator 3.5 kg/cm2.

2 Answers   Adani, Bell,

---

Explain force?

0 Answers  

---

Relate FDDI/ATM/SONET to the OSI model.

0 Answers  

---

successful command to make linux system as router in redhat-+

0 Answers  

---

(53/3)r=(15)r ,find the value of r?

6 Answers   HCL, Syntel,

---