Answer Posted / samir kumar sahoo
Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
Explain ddl (data definition language)?
What are the methodologies of data warehousing?
What are the different methods of loading dimension tables?
What are the different types of data warehouses?
What are the steps involved in creating dimensional modeling process?
if you use oracle sql*loader , how do you transform data with it during loading?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
what are the other factors of the database on which the loading performance depend?
What are the different types of join operations?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain about core dimension, balanced dimension, and dirty dimension?
Code the tables statement for a single-level (most common) frequency?
Explain what is the difference between a primary and secondary actor in use case modeling?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?