mobileNavlogo
headerlogo

Blog

Introduction to Informatica

26 September, 2020

Related Blogs

Reason for build Data Warehouse

Informatica

  • Data is scatted at different places
  • Data inconsistency Once place  Hyd
  • Depending on volatile and non-volatile  [Data keep on changing]
 

Informatica

Surrogate keys means artificial keys

Data Warehouse:- Ralph Kimball

A Data Warehouse is relation Database management system which is specifically design business analyses and making decisions to archive the business goals.

A Data Warehouse is designed to support decision-making process hence it is called as desiccation supporting system (DSS)

A Data Warehouse is historical Database which stores historical business information required for analysis.

A Data Warehouse is a “read only Database” which supports business manages to very the Data required for analysis, but not for business transactional processing.

A Data Warehouse is an integrated Database which stores the Data in an integrated formatted; the Data is collected from multiple OLTP source systems.

If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.

Data Warehouse:-(W.H.Inmon)

A Data Warehouse is a

  • time variant
  • Non-volatile
  • Subject oriented
  • integrated Database

Informatica

Ex:- Over Business Application:-

Informatica Business Application

Ex:- Over sales application:-

Informatica

Characteristic features of DataWarehouse:-

  • Time-variant:-

A DataWarehouse is a time-variant Database which supports business needs of end users in comparing and analyzing the business with different time periods. This is also known as time series analysis.

Informatica

Non-volatile:-

  • A Data Warehouse is a non-volatile
  • Once the Data entered into the Data Warehouse, it doesn’t reflect the change which takes place at operational Database. Hence the Data is “static” in the Data Warehouse.

Subject Oriented:-

A Data Warehouse is a subject oriented Database which supports the business need of department specific users.

Ex:- sales, accounts, hr. students, lones etc....

A subject is derived from multiple OLTP applications which organize the Data to meet specific business functionality.

Integrated:-

A Data Warehouse is an integrated Database which collects the Data from multiple OLTP Database

Informatica

E  T  M (move) A Data Warehouse s container to store the business information

Check Out Our Related Courses

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .