ER Modeling and Dimensional Modeling
Specify the difference between the ER Modeling and Dimensional Modeling?
Expert
a) ER Modeling is used in order to normalize the OLTP database design.
b) Dimesional modeling is used in order to de-normalize the ROLAP / MOLAP design.
Write down the four purposes of the selection of a data type?
Describe briefly How can we configure mapping in the informatica?
Explain briefly the term an outer join?
Which of the following method does not support sorting (Exchange, Selection, Insertion, Deletion)?
Explain the way to unzip a File in SSIS.
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
Which member function places a new node on the end of the linked list? Answer: appendNode(): This member function places a new node on the end of t
Elucidate briefly what is batch and also give explanation about the types of batches?
Provide a brief introduction on the term ‘cube grouping’?
Differentiate between start schma and Fsldm?
18,76,764
1946581 Asked
3,689
Active Tutors
1433509
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!