Data warehouse viva questions

  • What are the three 3 process used in a data warehouse?

    Process Flow in Data Warehouse
    Extract and load the data.
    Cleaning and transforming the data.
    Backup and archive the data..

  • What is data warehouse in short answer?

    A data warehouse is a central repository of information that can be analyzed to make more informed decisions.
    Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence..

Can a company use a data warehouse and a database?

Yes, a company may use a data warehouse and a database at the same workplace

But they do not have to be in the same physical data center

It all depends on the organization's requirements

Databases are often used to support transactions as they occur, whereas data warehouses are used to support business intelligence

What is the difference between data warehouse and data mart?

1

A data warehouse is a large centralized repository of data that contains information from many sources within an organization

The collated data is used to guide business decisions through analysis, reporting, and data mining tools

1

A data mart is a subset of a data warehouse oriented to a specific business line


Categories

Data warehouse views
Data warehouse vision statement examples
Data warehouse visual studio
Data warehouse visio template
Data warehouse view vs table
Data warehouse virtualization
Data warehouse visualization tools
Data warehouse visio
Data warehouse virtual machine azure
Data warehouse vision statement
Data warehouse view naming conventions
Data warehousing with greenplum
Data warehousing with python
Data warehousing with sql server 2012 pdf
Data warehousing with ssis
Data warehousing with spark
Data warehousing bootcamp
Data warehouse boolean string
Data warehouse bootcamp
Data warehouse boces