What is snow flake schema ?

Devarinti Bhaskar
Devarinti Bhaskar

Posted On: Dec 30, 2020

 

Related 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

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...

Cognizant Informatica interview questions

What are different types of SCD?

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 histo...