What are the different types of schemas?
Answer Posted / chowdary
There are two types of shemas
1 star schema , 2 snowflake schema
star schema : a fact table related to tha dimension tables
like in the fact table it contain refernce keys of
dimension tables. and dimension tables dont related to the
other parent table . it view like a star so its call star
schema. if this use to avoid more joins
snowflake schema: a dimenion table with related to the it
hirerchi tables. like time dimensin table year dimension
table, month month dimension table, week dimension table
it view like snowflake
Is This Answer Correct ? | 23 Yes | 26 No |
Post New Answer View All Answers
Which files are created during the session rums by informatics server?
what is index?how it can work in informatica
What are the tuning techniques you applied during your last project
What is the difference between informatica 7.0 and 8.0?
What the difference is between a database, a data warehouse and a data mart?
What are the static cache and dynamic cache in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Differences between version 7.x and 8.x.
What are Dimensional table?
What is the difference between a connected look up and unconnected lookup?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is repository manager?
Explain why we use partitioning the session in informatica?
What is the use of target designer?