Group Discounts available for 3+ students and Corporate Clients

Introduction to Informatica

Reason for build Data Warehouse

1

  • Data is scatted at different places
  • Data inconsistency Once place  Hyd
  • Depending on volatile and non-volatile  [Data keep on changing]
Desired to gain proficiency on Informatica? Explore the blog post on Informatica training to become a pro in Informatica.
 

Screenshot_1

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.

Data Warehouse:-(W.H.Inmon)

A Data Warehouse is a

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

Screenshot_2

Ex:- Over Business Application:-

Screenshot_3

Ex:- Over sales application:-

Screenshot_4

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.

Screenshot_5

 

 

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

Screenshot_6

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

Check Out Our Related Courses

Informatica Tutorials & Interview Questions

Informatica Concepts

Informatica MDM Tutorials

Informatica Training In Hyderabad

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Introduction to Informatica"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6