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
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain about cumulative Sum or moving sum?
How do you load alternate records into different tables through mapping flow?
What is a router transformation?
tell me 5 session failure in real time how can you solve that in your project?
How can you increase the performance in joiner transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain the types of lookup transformation?
What is fact table? Explain the different kinds of facts.
what is index?how it can work in informatica
What is a sequence generator transformation?
How do you take back up of repository?
How many dimensions are there in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is dynamic cache?