E – Extract setting the data
T-transformdoing Intermediate operation
L-LoadLoad to destination
Data stage, Informatica, AB-Initio, SSIS, OWB et
To create multi – Dimensional object and object and provides supports for multi –Dimensional analysis
COGNOS, BO, Hyperion, SSAS, Micro strategy, OBIEE etc.
To display the data in the understand and required format, we go for this,
COGNOS, BO, SSRS, Hyperion, Micro strategy B Crstal on OBIEE etc.
Inclined to build a profession as Teradata Developer? Then here is the blog post on
It is composed on observable and recordable facts, that are off be found in transaction(or)operation system
It is an integrated collection of facts and is used as the[organized – data is called information] bases for decision making
Need of dataware housing
To have single version of data, in single storage
To complete with other organization market
To analysis tactical strategic queries etc.
Definition of ODS, DWH, BI, OLTP, OLAP
On line transaction processing
Here day to day operations data available (immediate operation data) Here all the DML operation can be performed.
ODS(Operational data store)
It is data stag structure that acts like repository for near real time operational data rather than long trand data.
This ODS may for them become to enterprise operational database(or) stage area to data were house
DWH(Data were house)
It is data base structure, where huge data store, so that we can take appropriate decision
OLAP(Online Analytical processing)
It is an application that collects managing and present multi– dimensional data analysis and management purpose.
BI retrieve the data from data warehouse to make business decision and management(it can takes the help OLAP)
Data warehouse Definition
There are many authors founder define different approaches
SEAM KELLY etc.
Some people calling INMON father of data ware house
A Data ware house is subject oriented
Non-volatile, Data Granularity
Collection or data, in this support of
A Data warehouse is subject oriented, integrated, Non- volatile, time variant, separate collection of data
The data in data ware house should belong to a specific subject Area, Domain (or) Business
Entire banking, Information in single place Entire medias information in single place
By loading the data we need follows standardized mechanism, we have single management data
Naming conversion, coding measurement, data attribute etc.
Non – volatile
Data in the data were house data, should not updata and delete.
The data should be store based on time frame so that, we cab current month sales, what is
sales, what could be sales of future month
Check out the top Teradata Interview Questions now!
Where have should be separate traditional system
Where have should be high available etc.
Data Warehousing life cycle
It is combination of 3 life cycles creating a data base and modeling database.
ETL requirement gathering
ETL deployment and maintenance
Analytical life cycle
Requirement gathering analysis
Designing the objects
Create multi-dimensional object
Testing multi- dimensional object
Reporting life cycle
Reporting Publishers And maintenance.