Why should we use star schema in datawarehouse design?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jz
1) Query performance is high.
2) It consume less space compare to SnowFlake.
| Is This Answer Correct ? | 4 Yes | 6 No |
What are the different threads in DTM process?
Issue with Update override at Target table in Informatica.
 Informatica Checkpoints
What are mapplets? How is it different from a Reusable Transformation?
How many number of sessions can one group in batches?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
What are the circumstances that infromatica server results an unreciverable session?
What are the challenges you have faced in your project?
What are partitions in informatica and which one is used for better performance?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
write a query to get maximum salary from the employers table without duplicates....kindly help me
What are the advantages of informatica?