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
What is the use of target designer?
Define joiner transformation?
What are the settings that you use to configure the joiner transformation?
How can one identify whether mapping is correct or not without connecting session?
What is a predefined event?
What are the different options available for update strategy?
What is dimensional table? Explain the different dimensions.
How can we create index after completion of load process?
What is a joiner transformation?
Why do you use Mapping Parameter and mapping variable?
Explain incremental aggregation in informatica
What are active transformations.
What is Data Caches size?
Why sorter is an active transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
