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.
Explain the term iConv and oConv?
Explain the working of the IPC Stage?
Explain what is meant by the term catalog and its types in the cagonos?
Illustrate the multi value or multicolumn problem? Include an example not employed in the text.
List out the various detected patterns.
Describe the relationship among entity, entity class, and entity instance.
What is Datadriven?
Explain Data Page Locking in Sybase.
State various types of the input links within the data stage?
Write down the enhanced features in the Teradata V2R5 and V2R6?
18,76,764
1961194 Asked
3,689
Active Tutors
1430045
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!