Informatica Course Content

As part of our  informatica teaching SQL, informatica  powercenter, data warehouse concepts, Unix basics  for entering in to informatica job field.



Data Warehousing Concepts
  • Data Warehouse
  • DataMart
  • Data warehouse Architecture
  • Dimensional Modeling
  • Dimension Fact
  • Slowly changing Dimension
  • Confirmed Dimension
  • Degenerated Dimension
  • junk Dimension
  • Additive fact
  • Semiadditive Fact
  • Non Additive Fact
  • Bridge table
  • Startschema
  • Snowflakeschema
  • Factless Fact
  • Changed Data Capture
  • OLAP vs OLTP
  • PowerCenter and powermart
Power center Concepts  
  • Informatica Installation
  • Mappingdesigner
  • Repository manager
  • Workflow manager
  • Workflow monitor
  • Informatica Architecture
  • Source Definition
  • Target Definition
  • Transformation Developer
  • Mappings
  • Mapplet
  • TaskDeveloper
  • Worklet
  • Workflow
Sources 
  •  Working with relational Sources
  •  Working with Flat Files
Targets 
  • Working with Relational Targets
  • Working with Flat file Targets
Informatica transformations
  • Expression
  • Source qualifier
  • Router
  • Aggrigator
  • Filter
  • Update Strategy
  • Lookup and it types
  • Sequence generator
  • Joiner
  • Sorter
  • Union
  • Rank
  • Transaction Control
  • Normalizer
  • Stored Procedure
  • SQL
  • Debugging mappings


Advanced Informatica Concepts
  •  Unconnected lookup Transformation
  •  Unconnected Stored Procedure to Create and Drop Index
  •  Mapplet and Types of Mapplets
  •  Defining Reusable Transformations.
  •  User Defined Functions.
  •  Tasks And Types of Tasks.
  •  Worklet and Types of Worklets.
  •  Scheduling Work flow
  •  Constraint Based Load Ordering.
  •  Target Load Plan
  •  Types of Batch Processing
  •  Link conditions
  •  Mapping Parameters
  •  Mapping Variables
  •  Defining Session Parameters
  •  Session Recovery
  •  Difference Between Normal and Bulk Loading.
  •  Push Down Optimization.
  •  PMCMD Utility
  •  PMREP Utility
  •  Incremental Aggregation
  •  TYPES Of LookUp Caches.
  •  Static LookUp Cache
  •  Dynamic LookUp Cache
  •  Perisistance lookup Cache
  •  Shared LookUp Cache
  •  Sorter and Rank Cache.
  •  ETL UNIT Testing (8 test Cases)
  •  ETL PERFORMANCE TESTING (3 test cases)
  •  ETL Performance Optimization techniques
Task Implementations.
1 Session
2 Command
3 EMAIL
4 Timer
5 Event Wait
6 Event Raise
7 Decision
8 Assignment
9 Control
10 Worklet

Unix Basics
  • Basic commands in the real time what will use
  • how to use the unix environment
Real Time Scenarios
  • Changed Data Capture/incrimental Load
  • SCD type1,2,3
  • Dynamic file generation
  • Complex mapping
  • Will  give one realtime example for each tranformation
  • Working With FlatFiles direct and indirect
  • Working with Relational database(Oracle)
  • Error Handling
  • Code migration folder level and repository level
Other Important Concepts
  • Pushdown optimization
  • Lable
  • Shortcuts
  • Purge
  • Versioning
  • Query optimizer
  • Types of Cache
  • All Types of tasks
  • Mapplets
  • Reusable Transformation
  • UserDefinedFunctions
  • Scheduling workflow
  • Target Load Plan
  • Constraint Based Load order
  • Normal and bulk load
  • Link conditions
  • Mapping Parameters and variables
  • Session parameters and Variables
  • Session recovery
  • Incremental Aggregation
  • Informatica version differences