what is difference between scd2 and scd3

Answer Posted / mahesh225

SCD Type2 maintains the complete history and SCD Type3 will maintains one time history.

www.futuresoftworld.com
www.futureitem.com

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data cleaning? How can we do that?

553


What are the steps of implementing data warehousing?

526


What are the stages that are required in data warehousing?

509


Explain the difference between data ware house & data mart?

542


Explain what are the different methods of loading dimension tables?

499






Explain multivalued dependency?

566


Explain what are the advantages data mining over traditional approaches?

672


What is factless fact tables?

630


What is the difference between aggregate table and materialized view?

590


Explain what are fact, dimension, and measure?

545


What are the difference between snow flake and star schema?

505


What does level of granularity of a fact table signify?

618


What are the main steps to build the data warehouse?

649


What is Discrete and Continuous data in Data mining world?

2108


How to pivot row data using informatica?

504