Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 8138 Views
- CTS, Sonata, I also Faced
- E-Mail Answers
Answer Posted / venkat
In the aboue two (snow flake,star)schemas ,star schema is
best,because star schema is denormalised and star schema is
centrally located Fact table and surrounded by multiple
dimention tables.so fact table size can be calculated based
on the lowest level granularity of the dimentions.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Differentiate between a repository server and a powerhouse?
Why is sorter an active transformation?
How to load a Dimension ? and how to load a fact table?
How to load data in informatica ?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What does role playing dimension mean?
What is depict expression change?
What is meant by active and passive transformation?
Explain incremental aggregation in informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the different types of olap? Give an example?
Briefly describe lookup transformation?
Whats there in global repository
