INFORMATICA COURSE – LEARN @ YOUR CONVENIENCE

1.Introduction to Datawarehousing

1. Data Warehousing Concepts
2. Dataware housing (what/Why/How)
3. Data Modelling(Schemas, FACTS and DIMENSIONS)
4. Slowly Changing Dimensions
5. Metadata

2. Power Center Components

1. Designer
2. Repository Manager
3. Workflow Manager
4. Workflow Monitor

3. Informatica Concepts and Overview

1. Informatica Architecture.
2. Source Qualifier
3. Target Designer
4. Transformations
5. Mappings
6. Mapplets
7. Sessions
8. Tasks

4. Sources

1. Working with relational Sources
2. Working with Flat Files

5. Targets

1. Working with Relational Targets
2. Working with Flat file Targets

6. Transformations

1. Expression Transformation
2. Lookup Transformation
3. Sequence Generator Transformation
4. Filter Transformation
5. Joiner Transformation
6. Sorter Transformation
7. Procedural Transformation
8. Router Transformation
9. Aggregator Transformation
10. Update Strategy Transformation
11. Union Transformation
12. Rank Transformation
13. Transaction Control Transformation
14. Normalizer Transformation
15. Source Qualifier Transformation
16. Stored Procedure Transformation
17. XML Source Qualifier Transformation
18. Debugging Mappings

7. ADVANCED INFORMATICA CONCEPTS

1. Unconnected lookup Transformation
2. Mapplet a
3. Defining Reusable Transformations.
4. Tasks And Types of Tasks.
5. Worklet
6. Scheduling Work flow
7. Target Load Plan
8. Types of Batch Processing
9. Link conditions
10. Mapping Parameters
11. Mapping Variables
12. Defining Session Parameters
13. PMCMD Utility

8. TYPES Of LookUp Caches

1. Static LookUp Cache
2. Dynamic LookUp Cache
3. Perisistance lookup Cache
4. Shared LookUp Cache

9. Task Types:

1.  Session
2.  Command
3.  EMAIL
4.  Timer
5.  Event Wait
6.  Event Raise
7.  Decision
8.  Assignment
9.  Control
10.  Worklet