informatica Biginer guide

 

Architectural difference between Informatica9 and Informatica 8.x 

Architecture wise there are no differences between 8 and 9 but here are some new features added inpowercenter 9Lookup Transformation: Cache updates. We can update the lookup cache based on the results of anexpression. When an expression is true, We can add to or update the lookup cache. We can update thedynamic lookup cache with the results of an expression.

Multiple rows return: We can configure the Lookup transformation to return all rows that match alookup condition. A Lookup transformation is an active transformation when it can return more thanone row for any given input row.

SQL overrides for uncached lookups: In previous versions We could create a SQL override for cachedlookups only. We can create an SQL override for uncached lookup. We can include lookup ports in theSQL query.Database deadlock resilience: In previous releases, when the Integration Service encountered adatabase deadlock during a lookup, the session failed. Effective in 9.0, the session will not fail. When adeadlock occurs, the Integration Service attempts to run the last statement in a lookup. We canconfigure the number of retry attempts and time period between attempts.

SQL transformation: Auto-commit for connections. We can enable auto-commit for each databaseconnection. Each SQL statement in a query defines a transaction. A commit occurs when the SQLstatement completes or the next statement is executed, whichever comes first.

Session Log files rollover: We can limit the size of session logs for real-time sessions. We can limit thesize by time or by file size. We can also limit the number of log files for a session.

Passive transformation: We can configure the SQL transformation to run in passive mode instead of active mode. When the SQL transformation runs in passive mode, the SQL transformation returns oneoutput row for each input row.

XML transformation: XML Parser buffer validation. The XML Parser transformation can validate an XMLdocument against a schema. The XML Parser transformation routes invalid XML to an error port. When

Informatica Architecture Tutorial - Version 8 / 9

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 centralized location such as data warehouse or operational data store. Informatica powercenter has a service oriented architecture that provides the ability to scale services and share resources across multiple machines.

The architectural diagram of informatica is shown below:

Informatica Architecture Image

The important components of the informatica power center are listed below:

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.

Node: 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.

Powercenter Repository service: Accepts requests from the client to create and modify the metadata in the repository. It also accepts requests from the integration service for metadata to run workflows.

Powercenter Integration Service: The integration service extracts data from the source, transforms the data as per the instructions coded in the workflow and loads the data into the targets.

Informatica Administrator: Web application used to administer the domain and powercenter security.

Metadata Manager Service: Runs the metadata manager web application. You can analyze the metadata from various metadata repositories.