Informatica tutorial
Informatica 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.