Data Mart and Types of Data Marts in Informatica

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

• 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.

 

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

 

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.

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.

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 database	Similarity:- 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

Router Transformation in Informatica

Working with Tasks in Informatica

Informatica Components