explain in detail about type 1, type 2(SCD), typ

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

(Continued from previous question...)

explain in detail about type 1, type 2(SCD), type 3 ?

Type-1
Most Recent Value
Type-2(full History)
i) Version Number
ii) Flag
iii) Date
Type-3
Current and one Perivies value

(Continued on next question...)

Other Job Interview Questions

• What are conformed dimensions?
• What is Dimensional Modelling?
• What are conformed dimensions?
• What is Dimensional Modelling? Why is it important ?
• What are the possible data marts in Retail sales.?
• Can a dimension table contains numeric values?
• What is a lookup table?
• Why do we override the execute method is struts? Plz give me the details?
• What type of Indexing mechanism do we need to use for a typical datawarehouse?
• What is the difference between datawarehouse and BI?
• More...