Informatica PowerCenter Architecture

 Informatica PowerCenter Architecture

Informatica is an ETL tool used for extracting the data from various sources (flat files, relational database, xml etc), transform the data and finally load the data into a centralised location such as data warehouse or operational data store.

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

Informatica Powercenter has a service oriented architecture (SOA) that provides the ability to scale services and share resources across multiple machines. Informatica PowerCenter Architecture diagram is shown below

Informatica Tutorial | Informatica PowerCenter | Edureka

The Blue part shown in above image is same as version 8 and the green part is new in 9.

Now we know, what is the use of each component at server and client level. Whenever you want to develop a code, we first need to call server level Repository service to the Client level Repository manager(R). Then with the help of user credentials go inside the repository service at Repository manager(R) and create a folder.

Once you create folder in R then move to Designer(D). Then in PowerCenter Designer, with the help of same credentials go inside repository service and open the same folder by giving the double click. Then develop the code inside the folder in Designer. Here the code development is nothing but a process of data flow from which table(source table) to which table(target table) called mapping nothing but a defining ETL process. Learn more from Informatica training

Once code development is done at PowerCenter Designer then move to Workflow manager(W). Open the same folder in workflow manager as how in Designer and provide data base connection information inside the session once after creating session and database connection information individually. Then create workflow and assign session to the workflow. This developed code in Client tools is called as Meta data. Now save with Ctrl S.

Whenever you save code this Meta data will be physically saved in Repository Service at each client tool level but logically this Meta data will be saved in Repository database.

When you executing workflow, the repository service takes all the workflow related Meta data from Repository database and assigns it to integration service. With the help of Meta data, integration service goes to Source database and Extracts, Transforms and loads data to target database based on mapping that you developed in Informatica PowerCenter Designer. In this process integration service creates several logs among them session and workflow logs are important.

Informatica is a Service-Oriented-Architecuture (SOA) which contains the following important components.

Informatica Administrator: Web application used to administer the domain and PowerCenter

Informatica Domain: Domain is the primary unit for management and administration of services in Powercenter. The components of domain are one or more nodes, service manager an application services.

Nodes: Node is logical representation of machine in a domain. A domain can have multiple nodes. Master gateway node is the one that hosts the domain. You can configure nodes to run application services like integration service or repository service. All requests from other nodes go through the master gateway node.

Service Manager: Service manager is for supporting the domain and the application services. The Service Manager runs on each node in the domain. The Service Manager starts and runs the application services on a machine.

Application services: Group of services which represents the Informatica server based functionality. Application services include powercenter repository service, integration service, Data integration service, Metadata manage service etc.

Powercenter Repository: The metadata is store in a relational database. The tables contain the instructions to extract, transform and load data.

I hope you reach to a conclusion about Debugging in Informatica. You can learn more through online informatica training

Comments

Post a Comment

Popular posts from this blog

What is Power BI: Architecture and Features Explained

Image
We all know that Power BI is one of the best BI tools, and many organizations are using this tool to generate reports and dashboards to make effective business decisions. Before using the Power BI services and features, you should know about the Architecture of Power BI. Because, you should know how the Power BI services, components are being used to transform the data, create the reports and dashboards. To get in-Depth knowledge on Power BI you can enroll for a live demo on   Power BI online training Microsoft Power BI Architecture: Power BI is a business platform that includes several technologies to work together. It delivers outstanding business intelligence solutions. Power BI Architecture contains four steps.  Let us discuss these four steps giving insightful information about each one of them. Data Integration Data Transforming  Report & Publish Creating and Dashboard 1. Data Integration:  Data is extracted from different sources wh...
Read more

Fundamentals of Blockchain Network Security

Image
Blockchain is a revolutionary technology, yet its security is often over-exaggerated. While its design does help protect against a variety of different security threats, the technology is vulnerable to attack. In this post, we discuss three of the fundamental security assumptions of blockchain and how they are violated. (Mostly) Benign Participants Blockchain technology is designed to create a secure, decentralized, and distributed record of the history of the blockchain system. The way that this is accomplished is by relying on the network of blockchain participants to (mostly) act in their own best interests and in that of the system as a whole. To get in depth knowledge on  blockchain  , enrich your skills on  Blockchain online training  professionals Blockchain wants to make sure that users participate in block creation, so that the system remains decentralized. It does this by providing incentives for creating these blocks in the form of block reward...
Read more

Informatica BDM

Image
  Informatica Big Data Management (BDM) item is a GUI based incorporated improvement apparatus. This apparatus is utilized by associations to construct Data Quality, Data Integration, and Data Governance forms for their huge information stages.  It has worked in Smart Executor that underpins different preparing motors, for example, Apache Spark, Blaze, Apache Hive on Tez, and Apache Hive on MapReduce.  To get in-Depth knowledge on Informatica you can enroll for a live demo on  Informatica online training   Informatica BDM incorporates consistently with the Horton works Data Platform (HDP) Hadoop group in totally related angles, including its default approval framework. Officer can be utilized to uphold a fine-grained job based approval to information just as metadata put away inside the HDP bunch.  Informatica BDM underpins Kerberos validation on both Active registry and MIT-based key dispersion habitats. Kerberos verification is upheld by all methods of ex...
Read more