in which situations do u go for starflake schema ?
Answer Posted / padmavathi
When we bother about query performance we will go for
starschema modelling because in this modelling data
redundancy will be there while writing queries to retrive
data need not use more join conditions.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the main features of Oracle 8i with context to datawarehouse?
What are the performance considerations when working with aggregator transformation?
What do you mean by channel change?
How can a transformation be made reusable?
explain abt ur project architecture?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How many ways are there to create ports?
What is meant by query override?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is the difference between informatica6.1 and infomatica7.1
which one is better performance wise joiner or look up
What are the modules in Power Center
In warehouses how many schemas are there?
What is sq transformation?
Which files are created during the session rums by informatics server?