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
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Differentiate between router and filter transformation?
How many input parameters can exist in an unconnected lookup?
Explain why we use partitioning the session in informatica?
How can we improve session performance in aggregator transformation?
What is a sorter transformation?
What are the different versions of informatica?
What are the types of schemas we have in data warehouse.
What do mean by local and global repository?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the difference between informatica 7.0 and 8.0?
What is option by which we can run all the sessions in a batch simultaneously?
How to convert multiple rows to single row (multiple columns) in informatica
What is joiner change?