• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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 design 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 a 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 knows 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 to 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 organizes 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

Summary
Review Date
Reviewed Item
Introduction to Informatica
Author Rating
5

“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 *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.