Section- 1
Database and Datawarehouse fundamentals Review Database/RDBMS Fundamentals
- Database Concepts
- RDBMS Concepts including normal Forms
- SQL Fundamentals
- PL/SQL Fundamentals
DataWarehouse fundamentals
- OLTP Vs OLAP
- Basic assumptions in Datawarehouse Environments
- Understanding DW schemas
- Star/Snowflake etc
Section- 2
Informatica Concepts & Architecture
- Informatica Components, Versions
- Architectural overview
- Understanding repository
- Repository Clients
- Repository Manager
- Folders, Users and Security
- PmRep ge
- Source Object definitions
- Target Object definitions
- Transformations
- Mappings
- Workflows
- Monitoring Workflows
|
Section- 3
Informatica Mappings Basics
- Debugger
- Understanding transformations
- Source Qualifiers
- Joiner Transformation
- Aggregator, Expression
- External Procedure, Stored Procedure
- Filter, Lookup, Lookup Caches
- Normalizer, Rank, Router
- Sequence Number Generator
- Sorter, Update Strategy
Section- 4
Informatica Advanced topics
- Target options & Heterogeneous Targets
- Parameters and Variables
- Mapplets
- Reble Transformations
- Workflow configuration and techniques
- Session configuration
- Scheduling
- Pmcmd ge
- Promote to Test and Production environments
- Introduction to the Project
|