What is denormalization and when would you go for it?
Answer Posted / dhirendra kumar
DENORMALIZATION IS A TECHNIQUE TO MOVE FROM HIGHER TO LOWER NORMAL FORM IN ORDER TO SPEED UP THE DATABASE ACCESS.WHEN WE WANT TO DERIVE PHYSICAL DATA MODEL FROM LOGICAL DATA WE USE DENORMALIZATION.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Explain about relational database management systems?
Explain about the hierarchical model of the database?
What are the types of database model?
Why does this query return 0?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How to use online Backups?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What is dbms and its application?
What are the 18 schemas?
How long can an error message be in raiseerror function?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Write the fastest query to find out how many rows exist in a table?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
State the acid rules?