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 will be the approach?
How to Create a folder using pmrep command?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
what is the flat file partition and where have to specify it
what is the size of your data warehousing?
Issue with Update override at Target table in Informatica.
WHAT IS FACT TABLES?
Define the various join types of joiner transformation?
What is the scenario which compels informatica server to reject files?
What do you mean by worklet?
can we override a native sql query within informatica? Where do we do it?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.