What are different types of SCD?
Posted On: Dec 30, 2020
The different types of SCD are as follows:
Type 0 – Fixed Dimension. No changes allowed, dimension never changes.
Type 1 – No History. Update record directly, there is no record of historical values, only the current state.
Type 2 – Row Versioning.
Type 3 – Previous Value column.
Type 4 – History Table. Type 6 – Hybrid SCD.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Cognizant Informatica Interview Questions
What is Star schema in informatica?
Star Schema in a data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. As its structure resembles a star so it is known as a star schema....
Cognizant Informatica Interview Questions
What is snow flake schema ?
In the data warehouse, Snowflake Schema is a logical arrangement of tables in a multidimensional database...
Cognizant Informatica Interview Questions
How do remove duplicates values in informatica from DB and Flat file?
distinct property(keyword) is used to eliminate duplicate rows in Informatica from a database and a flat-file. We can eliminate duplicate rows from the flat-file by using group by function in an aggr...