Informatica ETL Tutorial

Hey buddy will you please get some information about the Informatica ETL Tutorial so that I can go through that information easily?

[Shaleen]

Feel free buddy I will help you here to get the information about the Informatica ETL Tutorial so that you can have idea about it.


Here is the details about Informatica ETL Tutorial
Informatica tutorial

Informatics basics:

Informatica components and architecture - Informatica PowerCenter services, client applications and modules.

Informatica ETL programs - information on basic Informatica components such as sources, targets, mappings, sessions, workflows

Mapping development tips - useful advices, best practices and design guidelines.

Informatica Powercenter weaknesses - things that make an Informatica developer's life harder.

Informatica Mappings development

Below a description of a few typical and most widely used development components:

Source qualifier - conversion of source datatypes to Informatica datatypes

Expression - transforming data with functions

Lookups - joining data with lookups

Sorter & Aggregator - sorting and aggregating data

Update Strategy expressions

Transaction control - how to create transactions and control commits and rollbacks

Java transformation - invoking Java methods, variables, third-party API's and built-in
packages with Java transformation

Informatica ETL process implementation

Parameters and variables in Informatica

Tasks - workflow tasks

Workflows - representation of the ETL process

Design best practices - Informatica mapping design tips, tricks and best practices

Informatica extensions and optional features

Powercenter Enterprise GRID - cost-effective scalability to ensure enhanced data integration and reduction of time needed for responding to business changes

Unstructure data extension for Informatica - with Unstructured Data Option data of any
format can be easily read integrated

Powerexchange for Tibco - a part of PowerExchange set of extensions is a virtual bridge
between Informatica solutions and TIBCO itself

Powerexchange for SAP Netweaver - integration between Informatica and SAP

Data masking components - out of the box data masking option in informatica

Real time edition - PowerCenter platform supplied with numerous real time operational
data integration capabilities.