Central repositories in a data warehouse can usually be populated from both operational databases and external sources.

Here's a step-by-step explanation:

1. Operational Databases: These are databases that are used by organizations for their day-to-day operations. They contain detailed and current data. For example, a bank may have an operational database that contains information about all its customers and their transactions.

2. External Sources: These are data sources that are not within the organization. They can include data from websites, data from social media, data from other companies, etc. For example, a company might use data from social media to understand customer sentiment about their products.

3. Populating the Central Repository: The data from these sources is extracted, transformed, and loaded into the central repository of the data warehouse. This process is known as ETL (Extract, Transform, Load).

4. The central repository in the data warehouse now contains data from both the operational databases and external sources. This data can be used for analysis and decision-making purposes.

So, the correct answer is "Operational database and external sources".

Question

Central repositories in a data warehouse can usually be populated from both operational databases and external sources.

Here's a step-by-step explanation:

1. Operational Databases: These are databases that are used by organizations for their day-to-day operations. They contain detailed and current data. For example, a bank may have an operational database that contains information about all its customers and their transactions.

2. External Sources: These are data sources that are not within the organization. They can include data from websites, data from social media, data from other companies, etc. For example, a company might use data from social media to understand customer sentiment about their products.

3. Populating the Central Repository: The data from these sources is extracted, transformed, and loaded into the central repository of the data warehouse. This process is known as ETL (Extract, Transform, Load).

4. The central repository in the data warehouse now contains data from both the operational databases and external sources. This data can be used for analysis and decision-making purposes.

So, the correct answer is "Operational database and external sources".

Knowee AI · Accepted Answer

Central repositories in a data warehouse can usually be populated from both operational databases and external sources.

Here's a step-by-step explanation:

1. Operational Databases: These are databases that are used by organizations for their day-to-day operations. They contain detailed and current data. For example, a bank may have an operational database that contains information about all its customers and their transactions.

2. External Sources: These are data sources that are not within the organization. They can include data from websites, data from social media, data from other companies, etc. For example, a company might use data from social media to understand customer sentiment about their products.

3. Populating the Central Repository: The data from these sources is extracted, transformed, and loaded into the central repository of the data warehouse. This process is known as ETL (Extract, Transform, Load).

4. The central repository in the data warehouse now contains data from both the operational databases and external sources. This data can be used for analysis and decision-making purposes.

So, the correct answer is "Operational database and external sources".

Central repositories in data warehouse usuallycan be populated from: Operational database and external sourcesOperational database onlyOperational database or external sourcesExternal sources onlySkipSubmit

Question

Solution

Similar Questions

Upgrade your grade with Knowee