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