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
What do you mean by worklet?
Explain the aggregator transformation?
How can we store previous session logs?
What is the format of informatica objects in a repository?
Define filter transformation?
list out all the transformations which use cache?
What is a joiner transformation and why it is an active one?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the use of an aggregator cache file?
What is meant by a domain?
How to call shell scripts from informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How to do the error handling of if ur source is flatfiles?
What is pmcmd command?
Scheduling properties,whats the default (sequential)