| Courses Software Training | Locality Marathahalli Outer Ring Road |
INFORMATICA Class Room / Online Training From Elegant IT Service.
Introduction—
1. ETL Overview
2. Basic Definitions of Data ware House
3. Informatica Architecture
4. Informatica Tools (Designer/Manager/Monitor)
5. Folders (Creation and their Importance’s)
Introduction to Informatica Designer:
1. Designer Tools
2. Defining Sources/Targets
a. Data Base
b. Flat File
3. Importing of Data base Objects
4. Creating New Target in Informatica
5. Creating target data base objects
6. Metadata Importance
7. Mapping Introduction / Mapplet Introduction
8. Active and Passive Transformations
9. Connected and Unconnected Transformations
10. Sample Mapping (Table/File)
11. Sample Mapping for each of the Transformations
12. Introduction to Source Qualifier and its Importance
13. Ports
14. Filter Transformation
15. Router Transformation
16. Lookup Transformation
17. Aggregator Transformation
18. Joiner Transformation
19. Union Transformation
20. Sequence Generator Transformation
21. Rank Transformation
22. XML Transformation
23. Stored Procedure Transformation
24. Normalizer Transformation (Discuss Theory part)
25. Sample Mapping with Mapping Parameters / Variables
26. Reusable Transformation
27. Mapplets
Workflow Manager / Monitor:-
1. Introduction
2. Tools
3. Create Workflow
4. Define Connections
5. Define Tasks (Command/Session/Link Conditions/Event Wait & Raise)
6. Setting Properties of Session (Constraint Based Loading/Update override/Target Load Plan)
7. Session Parameters
8. Execute Workflow
9. Monitoring Workflow in Monitor
Apart from above we can refer
Project explanation with Examples.
Type 1 & 2 Mappings,
PDO,
CDC,
Incremental Aggregation,
Incremental Loading,
Worklet and types of Worklets.
Thanks&Regards
Elegant IT Services,
#352, 2nd Floor,Aswath Nagar
Varthur main road,Near Railway Fly Over
Maratha halli,Land mark : Chemmunar Jewellers,
Bangalore - 560037.Ph:-9886541264/87