Teradata Material
Pages
(Move to ...)
Home
INFORMATICA
Fall Back,Journals and NODES
FASTLOAD
BTEQ
Teradata SQL
INDEXES
Teradata Architecture
MULTILOAD
CONTUCT US
▼
Showing posts with label
DATAWAREHOUSE
.
Show all posts
Showing posts with label
DATAWAREHOUSE
.
Show all posts
Thursday, 26 June 2014
Operational DataStore(ODS)
›
An ODS stands for - O perational D ata S tore. ODS is a database which is designed to integrate data from multiple sources for addi...
1 comment:
Fact tables
›
Fact - A fact table typically has two types of columns, foreign keys to dimension tables and measures those that contain numeric facts. A ...
Dimension tables in datawarehouse
›
Dimension - A dimension table typically has two types of columns, primary keys to fact tables and textual\descreptive data. Types of...
What is a staging area? Why we need it? What is the purpose of a staging area?
›
Staging area is place where we the hold temporary tables on data warehouse server. Staging tables are connected to work area or fact t...
What is Datamart ? why we need it? Types of Datamarts
›
Definition of datamart :– Datamart is a subset of a Data Warehouse that supports the requirements of a particular department or business...
Data Mining
›
Data mining is a process of extracting hidden trends within a datawarehouse. Example –An insurance datawarehouse can be used to mine ...
Advantages of Data Ware Housing
›
Below are the advantages of data warehousing:- Increase customer profitability Increase customer profitability Cost effective deci...
Data Warehouse lifecycle
›
Below is the Data Warehouse project lifecycle:- • Project Planning • Business Requirement Definition(SRS) • Technical Architecture...
Components of datawarehouse?
›
Below are the components of a data warehous e :- Source databases /systems (Example - Legacy, relational, text or external sources) Data...
What is datawarehousing ?
›
Data Warehousing is a process to properly assemble and manage data from various sources to answer business questions not previously possib...
›
Home
View web version