June 30, 2020

Explain about Informatica Data Warehousing

A Data Warehouse's basic idea is to promote a single version of reality for a firm. This is to make and forecast decisions. A Data Warehouse is an information system. Besides it includes a single or multiple source of historical and commutative data. Data Warehouse framework simplifies the organisation's monitoring and review process. In this article let us see about Data Warehousing in Informatica.

Informatica is a strong ETL tool by Informatica Corporation. This is a leading provider of applications for business data integration,ETL software.

To get in-Depth knowledge on Informatica you can enroll for a live demo on Informatica online training

Data Warehouse Tools and Utilities Features:

The following are tools and utility features for data warehouse.

  • Data Extraction:

Requires data collection from different heterogeneous sources

  • Software Cleaning :

This implies the detection and correction of software errors.

  • Data Transformation:

It transforms data into warehouse format from legacy format.

  • Data Loading:

Sorts, summarizes, consolidates, tests integrity and generates indices and partitions.

  • Refreshing :

This includes downloading into the warehouse from data sources.

In Informatica all metadata information about source systems, target systems. You can store transformations in Informatica's repository. Besides, you can use this archive by the Power Center Application. Registry Server at Informatica to store and retrieve metadata.

Types of Data Warehousing:

The types of data warehousing are as follows.

Power Center Client:

You may use Informatica clients to manage users, source and target framework concepts. Besides you can create mapping and mapplets, build sessions and run workflows etc.

Repository Server:

This repository server handles all communications. Besides, This is between the repository and the Power Center client.Learn more from Informatica training

Power Center Server:

Power Center server extracts data from source. Then loads it to targets.

Designer:

Source Analyzer, Mapping Designer, and Warehouse Designer are wizard tools. Source Analyzer is for metadata extraction from source systems. Mapping Designer is for mapping between sources and destinations. Besides, Mapping is a picturesque representation of the data flow from source to goal.

You may use Warehouse Designer to extract metadata from target systems. It is possible to construct metadata within the Designer itself.

Data Cleansing:

Data cleaning technology from the Power Center increases the consistency of data. This is by validating, correctly naming and standardizing the address data. Besides, in all source systems, the address of an individual may not be the same due to typos and postal code. The city name does not suit the address. Using a data cleaning procedure,you can fix these errors . You can load the structured data into target systems (data warehouse).

Transformation:

Transformations assist in transforming the source data according to the target device requirements. Sorting, filtering, grouping, joining are only some of the Transformation Instances. You can lead transformations to ensure the accuracy of the data into the target. Then you can achieve this from source to target during the mapping process.

Workflow Manager:

Workflow helps load data in a sequential from source to target. For example, you load the fact tables in front of the search tables. Now in this case, you will get the pop-up error message. This is as the fact table violates the foreign key validation. Then you may generate workflows to prevent this, to ensure the correct flow of data from source to target.

Workflow Control:

This control is useful in tracking and controlling the workflows. You can generate this on each Power Center Server.

Power Center Connect:

This portion assists in extracting data and metadata from ERP systems. This is such as IBM's MQSeries, Peoplesoft, SAP, Siebel. Get more skills from online informatica course

You may use this rather than third party applications.

Power Center Exchange:

This section helps collect data and metadata from ERP systems. These are such as IBM's MQSeries, Peoplesoft, SAP, Siebel. There are other software from third parties.

Informatica Power Exchange:

Power Exchange allows companies to optimize data. This is as a stand-alone service or together with Power Center, Informatica. This is done by preventing manual coding of data extraction programmes . Power Exchange supports batch, real-time and modified data capture options in mainframes. These are midrange and relational databases.

Power Channel:

This helps to transfer vast quantities of encrypted and compressed data. This is through LAN, WAN, Firewalls, FTP-transfer files, etc.

Metadata Exchange:

Metadata Exchange helps companies to take advantage of the time and resources. You need to define data structures within their IT environment. This is when used with Power Center. For example, an organization may use data modeling tools for designing data models. These models include Erwin, Embarcadero, Oracle designer, Sybase Power Designer etc.

Functional and technical teams would have spent a great deal of time and energy. It is to design the data structures of the system model . Then you need to import such data structures into the power center. This is by using meta information exchange to define source and goal mappings. Besides that require time and effort. Informatica creators don't need to build these data structures again.

Power Analyzer:

The Power Analyzer provides monitoring tools to organizations. It helps decision-makers to access, interpret, and exchange business data easily and conveniently. Power Analyzer offers insight into business processes. This allows the creation of business intelligence.

A company can collect, process, format, and analyze corporate data. The rom data storage may be in a data center, data mart, operational data storage. Besides you can also store other data storage models with Power Analyzer. This best accommodates in a relational database with a spatial data warehouse. It may also run data reports that do not adhere to the dimensional model. This may be in any table in a relational database.

Super Glue:

Super glue is to load metadata from multiple sources in a centralized location. Beside you may use Reports to evaluate meta data against this superglue.

Power Mart:

Power Mart is for the design, delivery of data warehouses and data marts. You can use the power center for data warehouses for large companies. People also use power marts for departmental data warehouses such as data marts. It supports global repositories and networked repositories, connectable to multiple sources. Power Mart supports a single server, and as compared with this you can link Power Center to fewer sources. Then Power Mart will extend to an enterprise application. This is through a codeless environment. It is easy for developer productivity to evolve.

Example for Data warehousing

To learn more about Metadata Source and Target you can take a bank as example. Find a bank with many branches worldwide. Besides, you can store data may in different source systems in each branch. The sources include oracle, sql server, teradata, etc.

When the Bank wants to incorporate its data for its management decisions . These may be from multiple sources. It can select one or more systems such as oracle, sql server, teradata, etc. as its target data warehouse. Many companies prefer the ETL method to Informatica. This is because Informatica is more efficient in designing and constructing data warehouses to extract metadata from sources and targets. Besides, it can link to multiple sources and targets, transform and load the data into target systems.

Working with Informatica Power Center Registry guidelines:

This is where you can store all of the metadata information in the Informatica suite. You can access this repository through the Power Center Client and Repository Server. Besides it allows you to download, store, and handle metadata.

Conclusion:

I hope you reach a conclusion about Data Warehousing in Informatica. You can learn more about Informatica from online Informatica training .