Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for starflake schema ?
- 6 Answers
- 19538 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
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How do you set a varible in incremental aggregation
Why update strategy and union transformations are active?
What is a filter transformation and why it is an active one?
What is informatica powercenter repository?
COM components can be used in Informatica
What is aggregator transformation in informatica?
can we override a native sql query within informatica? How do we do it?
Enlist the tasks for which source qualifier transformation is used.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to load the data from a flat file into the target where the source flat file name changes daily?
How can one identify whether mapping is correct or not without connecting session?
What is target designer and target load order?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you change a non-reusable transformation to reusable transformation?
