Interested to Buy Any Domain ? << Click Here >> for more details...
Why should we use star schema in datawarehouse design?
- 2 Answers
- 6172 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / arun
Star schema has less joins within its related dimensions so query retreival is faster than SNow-flake.
Space consumed is more than snow-flake
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
waht type of interface is used for testing the data in informatica
How to configure mapping in informatica?
What are mapplets? How is it different from a Reusable Transformation?
What is dynamic cache?
What is informatica? Why do we need it?
what is SDLC way of code development?
How might one distinguish in the case of mapping is right or not without associating session?
Explain dynamic target flat file name generation in informatica
What is the function of union transformation?
Which are the different editions of informatica powercenter that are available?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How we can create indexes after completing the loan process?
how tokens will generate?
What is Data Caches size?
write a query to retrieve the latest records from the table sorted by version(scd)
