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 is Operational Data Store?

609


Briefly state different between data ware house & data mart?

572


How to join 3 database like flat file, oracle, db2 in informatrica?

657


Explain what are components of reportnet?

561


why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1548






Explain a mapping, session, worklet, workflow, mapplet?

610


In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

1720


How to create different types of templates?

524


What is real-time datawarehousing?

612


Explain in detail abt measure objects? And what is the use of it? How to create it?

561


What are the other names given to data warehousing?

650


Who needs data warehousing?

573


What are algorithms provided by Microsoft in SQL Server?

1581


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

528


I know of using applysimple, but there are other ways too?

569