Why should we use star schema in datawarehouse design?

Answer Posted / jz

1) Query performance is high.
2) It consume less space compare to SnowFlake.

Is This Answer Correct ?    4 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many types of dimensions are available in informatica?

549


I have a flat file, want to reverse the contents of the flat file

680


In informatics server which files are created during the session rums?

622


Do you find any difficulty while working with flat files as source and target?

662


Explain the informatica workflow?

577






To import the flat file definition into the designer where should the flat file be placed?

665


What are the informatica performance improvement tips

603


What is a node in Informatica?

611


What are the tasks that can be performed using sq?

600


How might you approve all mappings in the archive all the while?

592


Explain the aggregator transformation?

617


In informatica workflow manager, how many repositories can be created?

771


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1546


list out all the transformations which use cache?

676


Which transformation is needed while using the Cobol sources as source definitions?

717