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
How are the sources and targets definitions imported in informatica designer?
What is a standalone command task?
How many dimensions are there in informatica?
In informatics server which files are created during the session rums?
Explain what is informatica metadata and where is it stored?
What is meant by query override?
What is lookup change?
What is the use of transformation?
What is substr in informatica?
What is intricate mapping?
Is there any target staging area in informatica not staging area
What are the new features of informatica 9.x developer?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the static cache and dynamic cache in informatica?
Differentiate between reusable transformation and mapplet.