Ginni has Published 1522 Articles

What are the tools and utilities of a data warehouse?

Ginni

Ginni

Updated on 22-Nov-2021 07:47:24

3K+ Views

Data Warehousing is a technique that is mainly used to collect and manage data from various sources to give the business a meaningful business insight. A data warehouse is specifically designed to support management decisions.In simple terms, a data warehouse refers to a database that is maintained separately from an ... Read More

What is a Three-tier Data Warehouse Architecture?

Ginni

Ginni

Updated on 22-Nov-2021 07:41:42

2K+ Views

Data Warehouses usually have a three-level (tier) architecture that involves −The bottom tier is a warehouse database server that is relatively always a relational database system. Back-end tools and utilities are used to feed records into the bottom tier from operational databases or other external sources (including user profile data ... Read More

What is the process of data warehouse design?

Ginni

Ginni

Updated on 22-Nov-2021 07:39:53

4K+ Views

A data warehouse can be built using three approaches −A top-down approachA bottom-up approachA combination of both approachesThe top-down approach starts with the complete design and planning. It is helpful in cases where the technology is sophisticated and familiar, and where the business issues that must be solved are clear ... Read More

Why do Business Analysts need Data Warehouse?

Ginni

Ginni

Updated on 22-Nov-2021 07:38:15

528 Views

Data Warehousing is a technique that is mainly used to collect and manage data from various sources to give the business a meaningful business insight. A data warehouse is specifically designed to support management decisions.In simple terms, a data warehouse defines a database that is maintained independently from an organization’s ... Read More

What are the components of a data warehouse?

Ginni

Ginni

Updated on 22-Nov-2021 07:36:42

3K+ Views

The major components of a data warehouse are as follows −Data Sources − Data sources define an electronic repository of records that includes data of interest for administration use or analytics. The mainframe of databases (e.g. IBM DB2, ISAM, Adabas, Teradata, etc.), client-server databases (e.g. Teradata, IBM DB2, Oracle database, ... Read More

Why do we need a separate Data Warehouse?

Ginni

Ginni

Updated on 22-Nov-2021 07:35:16

6K+ Views

Data Warehousing is a technique that is mainly used to collect and manage data from various sources to give the business a meaningful business insight. A data warehouse is specifically designed to support management decisions.In simple terms, a data warehouse refers to a database that is maintained separately from an ... Read More

What is Data Warehouse?

Ginni

Ginni

Updated on 22-Nov-2021 07:32:04

1K+ Views

Data Warehousing is a technique that is mainly used to collect and manage data from various sources to give the business a meaningful business insight. A data warehouse is specifically designed to support management decisions.In simple terms, a data warehouse defines a database that is maintained independently from an organization’s ... Read More

What is Data Cube Aggregations?

Ginni

Ginni

Updated on 22-Nov-2021 07:27:09

6K+ Views

Data integration is the procedure of merging data from several disparate sources. While performing data integration, it must work on data redundancy, inconsistency, duplicity, etc. In data mining, data integration is a record preprocessing method that includes merging data from a couple of the heterogeneous data sources into coherent data ... Read More

What is the difference between Hardware firewalls and Software Firewalls?

Ginni

Ginni

Updated on 22-Nov-2021 05:33:05

601 Views

Let us understand what a hardware firewall is.Hardware FirewallHardware firewalls are frequently built within the base of broadband routers and are an essential part of a network setup, particularly on a broadband connection. A hardware firewall can be very adequate with minimal or no configuration and can guard each device ... Read More

What is the difference between VPN and APN?

Ginni

Ginni

Updated on 22-Nov-2021 05:32:06

401 Views

Let us begin by learning about VPN.VPNVPN stands for the virtual private network. It is an encrypted connection over the web from a device to a network. The encrypted connection supports that sensitive information is safely communicated. It avoids an unauthorized person from eavesdropping on the traffic and enables the ... Read More

Advertisements