4.Explain Snowflkeschema ?

Answer Posted / sanjeev_mis

One dimension is not connected directly to the fact table, instead, it is connected through another dimension table.
... SANJEEV SHARMA

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of datawarehosuing?

569


How to define a cube??

553


What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

527


Why should you put your data warehouse on a different system than your oltp system?

504


In a star schema, are foreign key constraints between facts and dimensions neccessary?

550






How to improve session performance in aggregator transformation?

538


how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

1729


What according to you might be the future of data warehousing?

534


What are the steps of implementing data warehousing?

540


Explain how are the dimension tables designed?

570


What are non-additive facts in detail?

543


What is surrogate key? Where we use it? Explain with examples.

549


What are the possible data marts in retail sales?

540


Explain what is a three tier data warehouse?

548


What is the purpose of cluster analysis in data warehousing?

570