Informatica Online Training.
Enquire.Join and get training by Well Experienced & Certified tutors for your professional Courses.
Watch Sample Session!INFORMATICA COURSE – LEARN @ YOUR CONVENIENCE
1.Introduction to Datawarehousing
- Data Warehousing Concepts
- Dataware housing (what/Why/How)
- Data Modelling(Schemas, FACTS and DIMENSIONS)
- Slowly Changing Dimensions
- Metadata
2. Power Center Components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
3. Informatica Concepts and Overview
- Informatica Architecture.
- Source Qualifier
- Target Designer
- Transformations
- Mappings
- Mapplets
- Sessions
- Tasks
4. Sources
- Working with relational Sources
- Working with Flat Files
5. Targets
- Working with Relational Targets
- Working with Flat file Targets
6. Transformations
- Expression Transformation
- Lookup Transformation
- Sequence Generator Transformation
- Filter Transformation
- Joiner Transformation
- Sorter Transformation
- Procedural Transformation
- Router Transformation
- Aggregator Transformation
- Update Strategy Transformation
- Union Transformation
- Rank Transformation
- Transaction Control Transformation
- Normalizer Transformation
- Source Qualifier Transformation
- Stored Procedure Transformation
- XML Source Qualifier Transformation
- Debugging Mappings
7. ADVANCED INFORMATICA CONCEPTS
- Unconnected lookup Transformation
- Mapplet a
- Defining Reusable Transformations.
- Tasks And Types of Tasks.
- Worklet
- Scheduling Work flow
- Target Load Plan
- Types of Batch Processing
- Link conditions
- Mapping Parameters
- Mapping Variables
- Defining Session Parameters
- PMCMD Utility
8. TYPES Of LookUp Caches
- Static LookUp Cache
- Dynamic LookUp Cache
- Perisistance lookup Cache
- Shared LookUp Cache
9. Task Types:
- Session
- Command
- Timer
- Event Wait
- Event Raise
- Decision
- Assignment
- Control
- Worklet