Is there any advantage to denormalizing DB2 tabl

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Is there any advantage to denormalizing DB2 tables?

Denormalizing DB2 tables reduces the need for processing intensive relational joins and reduces the number of foreign keys.
In datawarehouse environment, mostly all the tables are semi- normalized ( ie it is fully normalized) to reduce no of joins . so de-normalization is having lot of advantages in datawarehouse .

(Continued on next question...)

Other Job Interview Questions

• What are the various locks available?
• What is difference between 911 and 913 error code in DB2 ?
• Where do you specify them ?
• What do you mean by NOT NULL WITH DEFAULT? When will you use it?
• What is COPY PENDING status?
• What happens to the PLAN if index used by it is dropped?
• What is stored in tables under creator SYSIBM?
• What is the meaning of underscore ( ‘_’ ) in the LIKE statement? –
• What is ACQUIRE/RELEASE in BIND?
• What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
• More...