Interested to Buy Any Domain ? << Click Here >> for more details...
Why should we use star schema in datawarehouse design?
- 2 Answers
- 5977 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Which transformation should u need while using the cobol sources as source defintions?
What is the Router transformation?
How to load time dimension?
What is joiner cache?
how to use incremental load?
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
What is the difference b/w natural key and surrogate key
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
when we dont use aggregator in mapping ?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
server hot-ws270 is connect to Repository B. What does it mean?
Teradata 
