0
A data warehouse is a centralized pool of data. Data warehouse is basically a repository where large amount of data is stored . The advantage of data warehouse is that we can archive the data that is not used in a long time.
Wiki User
∙ 9y ago
mark_b20
Nidhi Gurjar
A data warehouse is a centralized repository that stores large amounts of structured and sometimes unstructured data from various sources. It is designed to support business intelligence (BI) activities, including reporting, analysis, and data mining. The primary purpose of a data warehouse is to provide a consolidated and historical view of an organization's data to facilitate decision-making processes.
Data migration, on the other hand, refers to the process of transferring data from one system or storage location to another. It involves extracting data from the source system, transforming and cleaning it as necessary, and then loading it into the target system or data warehouse. Data migration is commonly performed when organizations upgrade their systems, implement new software, merge with other companies, or consolidate data from multiple sources.
The migration process typically involves several stages, including:
Planning: Defining the goals, scope, and requirements of the migration project, identifying data sources and destinations, and developing a migration strategy.
Extraction: Extracting data from the source system, which may involve accessing databases, files, or APIs and converting data into a suitable format for migration.
Transformation: Cleaning, reformatting, and restructuring the data to align with the target system's data model and standards. This may involve data cleansing, data mapping, and data validation.
Loading: Importing the transformed data into the target system or data warehouse. This step may include data validation and verification to ensure data integrity.
Testing and validation: Verifying the migrated data for accuracy, completeness, and consistency. This step involves conducting tests, comparing data between the source and target systems, and resolving any discrepancies.
Deployment: Making the migrated data available for users or applications to access and utilize in the new system or data warehouse.
Data warehouse migration, specifically, refers to the process of migrating data from an existing data warehouse to a new one. This can be driven by various factors such as upgrading technology, improving performance, accommodating increased data volume, or changing business requirements. The migration process for a data warehouse involves careful planning, data extraction, transformation, loading, and validation to ensure a successful transition while preserving data integrity and accessibility.
Wiki User
∙ 12y agoA data warehouse is a central repository where data from multiple sources is combined ideally in a standardized data structure.
Add your answer:
Earn +20 pts
What is features of data warehouse system?
data are rarely deleted
What are the differences data warehouse between data mining?
Data warehouse is a technology that aggregates structured data from one or more sources so that it can be compared and analyzed rather than transaction processing, whereas Data mining is the process of analyzing unknown patterns of data.
Where is the Amazon warehouse located?
Arizona
What is RG23D?
Any material that has to move from RG23D warehouse should have Excise invoice(RG23D) generated for the transaction. What I suppose is for this after doing a normal warehouse transfer, you have to issue the material from the folio of the register maintained for the specific RG23D warehouse. Then you have to raise an Excise invoice for the ware house transfer transaction. In normal ware house you have to do nothing but see weather the inventory has been posted in the normal warehouse or not.
Difference between inventory and warehouse?
Inventory include materials, loose tools and finished products of an enterprise. Warehouse is the place for keeping the inventory for future use.
What is data where housing and mining?
it's data warehouse....data warehouse: it is a collection of multiple databases or it it is repository of data.data mining it is the process of extracting data from data warehouse.
What describes contents of a data warehouse?
Meta-Data
What do you mean by data warehouse?
Data warehouse is a house where current as well as historical data can be stored.
What are the key relationships between data warehouse and data mining?
Data warehouse is the database on which we apply data mining.
How does Data Warehouse differ from Data Mart?
Data marts are combined into a data warehouse cannot be built alone without considering data marts. Both has equal importance to built proper data warehouse.
Every data structure in data warehouse contains time element?
Every data structure in the data warehouse contains the time element. Why?
What are benefits of data warehouse?
One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.
What makes the best data warehouse architecture?
A data warehouse architecture is similar to various relational database systems. What makes the best architecture is the organization of the warehouse itself and the data it consist of.
What are the advantages of a warehouse?
Data warehouse is the pool of huge amount of data. The data in data ware house can be archived. And when the data is needed you can extract it from the archived files.
How does data mining form?
catch important data from data warehouse.
What has the author Tom Debevoise written?
Tom Debevoise has written: 'The data warehouse method' -- subject(s): Data warehousing 'Data Warehouse Method, The'
What is a smaller version of a data warehouse?
What are the three most common forms of data warehouses? is a smaller form of a data warehouse that is often used by a single department or function. An independent data mart is a tiny warehouse that is built for a strategic business unit (SBU) or a department, but it does not have a central data source (EDW). To learn more about data science please visit- Learnbay.co
