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.