Interested to Buy Any Domain ? << Click Here >> for more details...
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
Define enterprise data warehousing?
When do you use sql override in a lookup transformation?
What is target load order?
How do you take back up of repository?
In informatics server which files are created during the session rums?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is Index Caches size?
How identifying bottlenecks in various components of informatica and resolving them?
What are the differences between source qualifier and joiner transformation?
What do you mean incremental aggregation?
Where is metadata stored?
What are the advantages of using informatica as an etl tool over teradata?
What is dimensional table? Explain the different dimensions.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is main use of mapplet?
