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 - useful tips, 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.
Read more BI and Dw articles, tutorials and data warehousing software comparisons on www.bi-dw.info
|