Discuss the advantages & Disadvantages of star & snowflake
schema?

Answer Posted / hania

Star Schama : easy for users to understand, optimize navigation and more suitable for query processing, and works faster.

Disadvantages: Dimension table have greater rows, large fact table

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by worklet?

721


Explain the aggregator transformation?

725


How can we store previous session logs?

656


What is the format of informatica objects in a repository?

690


Define filter transformation?

718






list out all the transformations which use cache?

767


What is a joiner transformation and why it is an active one?

653


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3446


What is the use of an aggregator cache file?

775


What is meant by a domain?

741


How to call shell scripts from informatica?

662


Which means the first record should come as last record and last record should come as first record and load into the target file?

690


How to do the error handling of if ur source is flatfiles?

1602


What is pmcmd command?

766


Scheduling properties,whats the default (sequential)

1550