INFORMATICA

INFORMATICA

Informatica Corporation is a software development company founded in 1993

Informatica's product is a portfolio focused on

 data integration:

 ETL,

 information lifecycle management,

 B2B data exchange,

 cloud data integration, 

complex event processing,

data masking

data replication, 

data virtualization, 

master data management,

ultra messaging.

 These components form a toolset for establishing and maintaining enterprise-wide data warehouses. It has a customer base of over 5,000 companies

Informatica ETL product, known as Informatica Power Center consists of 3 main components.

Informatica Power Center Client Tools:

These are the development tools installed at developer end. These tools enable a developer to

1.     Define transformation process, known as mapping. (Designer)

2.     Define run-time properties for a mapping, known as sessions (Workflow Manager)

3.     Monitor execution of sessions (Workflow Monitor)

4.     Manage repository, useful for administrators (Repository Manager)

5.     Report Metadata (Metadata Reporter)

Informatica Power Center Repository:

1.   Repository is the backend of Informatica tools.

 Repository is a data inventory where all the data related to

1.   mappings,

2.   sources,

3.   targets etc. is kept.

This is the place where all the metadata for an application is stored. All the client tools and Informatica Server fetch data from Repository.

Informatica Power Center Server:

 In the Server, all the executions take place. Server makes physical connections to sources/ targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system.

Types of transformations[edit]

·         Active : One that can change the number of rows being output.

·         Passive : One that cannot change the number of rows being output.

·         Connected : One that has at least one link with other transformations or objects in a mapping

·         Unconnected : One that does not have any link with any transformations or objects in a mapping

Also, Active transformation are recognized by any of the following three factors:

the transformation changes the row type

the transformation changes the row order

transaction control happens in the transformation

A transformation which has these properties is said to be an "active transformation", otherwise it is said to be a "passive transformation".

Examples:

Source qualifier –

converts source data types to Informatica data types; joins two source tables or files of the same type

Expression –

transforms data with functions without affecting cardinality or data order

Lookups –

enhances data elements with lookup values; may be connected or unconnected

Filter –

filters incoming data

Router –

routes data to selected output paths

Sorter –

sorts data and optionally removes duplicate rows

Aggregator – 

aggregates data

Joiner – 

joins relational data midstream; can be used when source data is of multiple types

Normalizer –

 used with flat file input containing arrays or repeated data to create normal form relational data

Update Strategy –

 determines whether data is to be updated, inserted or deleted in cases where there are multiple output targets

Transaction Control –

creates transactions and controls commits and rollbacks

Sequence Generator –

 generates a sequence of unique values as per the specified parameters

Java transformation –

 invokes Java methods, variables, third-party API's and built-in packages.