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 |
can you please explain me pre session and post session options?
how can we use sorter transformation in joins?
how the server recognises , if the session fails after loading the 100 records in to the target
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
Separate from a database, an information bazaar, and an information stockroom?
What is the status code in stored procedure transformation?
version controlling in informatica?
normalizer transformation
what is data driven?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
what are the settiings that u use to cofigure the joiner transformation?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan