Data Mart and Types of Data Marts In Informatica

Data Mart

A Data Mart is a subject-oriented database that supports the business needs of department-specific business managers.

(or)

A Data Martin Informatica is a subject of an enterprise data warehouse a data mart is also known as high-performance query structures (HPQS)s.

There are two types of data mart

  • Independent data mart
  • Dependent data mart

Data Mart and Types of Data Marts in Informatica

  • The enterprise is a integration of various department
  • Integration of multiple data mart is a enterprise DHW.

Difference between enterprise Data Warehouse and Data Marts in Informatica

EDW

Data Mart

  • It is an integration of multiple subjects

1. It defines a single subject

  • It stores enterprise specific business information

2. It stores department specific information

  • Design for top management (CEO, board of director)

3. design for middle management users

 

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.

 Top-Down data warehousing approach - (W.H. Inman)

 According to the Inman first we need to build an enterprise data warehouse, from the EDW design subject oriented, department specific database known as data marts.

informatica data warehousing  

Bottom – up data warehousing approach - Kimball

According to the Kimball design department specific, subject oriented database know as data marts, integrate the data marts to define enterprise data warehouse

informatica datawarehouse  

Dependent Data Mart

In a top-down approach a data mart development “dependants” on enterprise data warehouse hence data mart are know as dependent data mart.

Learn Informatica Online With free Tutorials

Independent Data Mart

In a bottom-up approach a data mart development is “Independent” of enterprise data warehouse. Hence such data mart are know as independent data mart.

Learn Informatica Online With free Tutorials

Operational Data Store

An Operational Data Store (ODS) is an integrated database of operational data. Its sources include legacy systems and it handles current or any near term data. An ODS may contain 30 to 60 days of information, while a data warehouse typically contains years of data.

An operational data store is basically a database that is used for being an interim area for a data warehouse. As such, its primary purpose is for handling data which are progressively in use such as transactions, inventory and collecting data from Point of Sales. It works with a data warehouse but unlike a data warehouse, an operational data store does not contain static data. Instead, an operational data store contains data which are constantly updated through the course of the business operations.

 

ODS

DSS (Decision Supporting System)DWH
Similarity:- Integrated databaseSimilarity:- Integrated data base
Differences:- 1. Volatile data

  • Current data
  • Detailed data

Difference:-1. Volatile data2.  Historical data3. summary data

Informatica Power Center 8.6.0

Informatica Power Center is a single unified data integration platfom, which allows company and organization to access the data from various type of source system transforming the data in to a homogeneous format and delivers the data through the enterprise at any speed.

Informatica Power Center is a client server technology and integrated tool set used to for designing running, monitoring and administrating that data acquisition application known as “mappings”.

A mapping is a graphical represent of data flow from source to target.

For indepth understanding of Informatica click on