Answer Posted / anju
Kimball: Data warehouse is combined of all the data marts
in an enterprise.Inofrmation is stored in dimensional model
Inmon:Datawarehouse is a part of business Intelligence
system. An enterprise has one data warehouse and data marts
source information from the datawarehouse.Information is
stored in 3rd normal form
Practically most of the enterprise data warehouses
following Ralph Kimball's methodology.Started as Data marts
and then evolve into data warehouse.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
How to generate sequence numbers?
To import the flat file definition into the designer where should the flat file be placed?
Informatica Checkpoints
What are the limitations of joiner transformation?
r u done any partitions in ur project?
How would you copy the content of one repository to another repository?
How to create or import flat file definition in to the warehouse designer?
What is the function of look up transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Differentiate between a repository server and a powerhouse?
What are the features of complex mapping?
What happens when a session fails and you click on recover?
How to configure mapping in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain lookup transformation in informatica