Interested to Buy Any Domain ? << Click Here >> for more details...
Why should we use star schema in datawarehouse design?
- 2 Answers
- 6095 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
What are the static cache and dynamic cache in informatica?
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
What is the difference between informatics 7x and 8x and what is latest version?
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
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
what is SDLC way of code development?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is different between the data warehouse and data mart?
What is a filter transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is dimensional table? Explain the different dimensions.
What do you mean by filter transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is workflow? What are the components of the workflow manager?
What are the popular informatica products?
