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
how many types of dimensions are available in informatica?
I have a flat file, want to reverse the contents of the flat file
In informatics server which files are created during the session rums?
Do you find any difficulty while working with flat files as source and target?
Explain the informatica workflow?
To import the flat file definition into the designer where should the flat file be placed?
What are the informatica performance improvement tips
What is a node in Informatica?
What are the tasks that can be performed using sq?
How might you approve all mappings in the archive all the while?
Explain the aggregator transformation?
In informatica workflow manager, how many repositories can be created?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
list out all the transformations which use cache?
Which transformation is needed while using the Cobol sources as source definitions?