How to Building a data warehouse

How to Building a data warehouse?

The process of building a data warehouse is as follows:

a) Identify the required types of queries or most frequently raised queries

b) Identify the sources of these data elements

c) Define the mode/frequency of updation/maintenance of data warehouse.

Data cleansing Means

Data cleansing Means?

A data warehouse integrates data from its identified sources. Often those sources don't match in terms of descriptive attributes and in many cases even in terms of unique identifiers. Data cleansing is required to evaluate at all the data coming from different sources and convert them to a single format before they are passed to a data warehouse. 

Difference between data warehousing, data mining and Business Intelligence

Difference between data warehousing, data mining and Business Intelligence?

Data Warehousing – Repertoire of Raw & Processed data

Data Mining – Tools to extract needed data/information

Business Intelligence – Usage of tools for better business decision-making 

What is DLL

What is DLL?

A Dynamic Link Library (DLL) is a collection of small programs, any of which can be called when needed by a larger program that is running in the computer. The small program that lets the larger program communicate with a specific device such as a printer or scanner is often packaged as a DLL program (usually referred to as a DLL file). 

What are forms

What are forms?

The visual part of the application with which the user interacts is called the interface. Forms & Controls the building blocks used to create the interface. Visual Basic forms all objects that have properties (define appearance), Methods (define behaviour) and Events (define interaction).

What is an index

What is an index?

Adding indexes to the database enables SQL to use the direct access method, by creating a tree like structure for quick access of records in a database.

How to RACLE password

How to RACLE password?

Issue the following SQL command:

ALTER USER <username> IDENTIFIED BY <new_password>/

From Oracle8 you can just type "password" from SQL*Plus, or if you need to change another user’s password, type "password user_name".