Interested to Buy Any Domain ? << Click Here >> for more details...
Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 9493 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
Please let me know how to make encryption and decryption with example?
What is a repository manager?
Where can we find the throughput option in informatica?
Global and Local shortcuts. Advantages.
What are connected or unconnected transformations?
How can you define user defied event?
How to handle decimal places while importing a flatfile into informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to load the data from people soft hrm to people soft erm using informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
Define pmcmd command?
Describe an informatica powercenter?
What does update strategy mean, and what are the different option of it?
What does role playing dimension mean?
