Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for starflake schema ?
- 6 Answers
- 19860 Views
- TCS, I also Faced
- E-Mail Answers
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
How you know when to use a static cache and dynamic cache in lookup transformation?
How does a rank transform differ from aggregator transform functions max and min?
How are the sources and targets definitions imported in informatica designer?
What is the difference between source qualifier transformations source filter to filter transformation?
How can we store previous session logs?
What is substr in informatica?
Explian the Process of deployment groups in informatica
How do you handle two sessions in Informatica
can we override a native sql query within informatica? Where do we do it?
How an expression transformation differs from aggregator transformation?
On which transformations you created partitions in your project?
EXL informatica Questions
Explain about Informatica server process that how it works relates to mapping variables?
How to create a non-reusable instance of reusable transformations?
What is decode in static cache?
