Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srikanth nallapati
star schema is a centrelized fact table surrounded by
dimention tables.where dimention tables are denormalized .
here the number of joins are less then the query
performence good.
but in snow flake schema dimention tables are normalized
here we can view lowest level granularity .here the number
of joins are high comparing to snowelake schema then
automatically performence is degread.
Note:performence is depending upon the requirement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can any one give some examples for pre sql and post sql(Except dropping and creating index).
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
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?
tell me about your project functionality
What are roles and groups and benefits of using them?
Which transformation should we use to normalise the COBOL and relational sources?
In which transformation you cannot drag ports into it?
How to join three sources using joiner? Explain though mapping flow.
What do mean by local and global repository?
What is the Rank index port in Rank transformation?
Explain why we use partitioning the session in informatica?
What are the advantages of using informatica as an etl tool over teradata?
Mention few power centre client applications with their basic purpose?
How would you join a node to the already existing domain?
What is the Process to creating lookup transformation in informatica
