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 different types of olap? Give an example?
Which files are created during the session rums by informatics server?
scenario where i can use only concurrent execution of workflow.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How many transformations can be used in mapplets.
What is dynamic cache?
How to update a particular record in target with out running whole workflow?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to elaborate powercenter integration service?
What is an unconnected transformation?
What are the tasks that source qualifier perform?
Explain the informatica workflow?
How we can create indexes after completing the load process?
Explain sessions. Explain how batches are used to combine executions?
How can you differentiate between powercenter and power map?