|
Informatica
Duration : 30 hrs
The Overview of following key topics (Necessary for any ETL Tool Training)
• DataWarehouse
• Data Mart
• ETL Architecture
1. Informatica Tools
2. Informatica Architecture
2. Basic Flow in Informatica
3. Defining Sources
4. Defining Targets
5. Working with Database
6. Working with Flat Files
7. Staging Tables and their role
8. Different Transformations
o Expression
o Filter
o Lookup
o Aggregator
o Sorter
o Joiner
o Update Strategy
o Sequence Generator
o Source Qualifier
o Router
o Union
o Stored Procedure
o Transaction Control
9. Sessions
10. Workflow
11. Working with Parameter Files
12. Connected/Unconnected Transformations
13. Mapping Variables/Parameters
14. Database Connections
15. DTM Process
16. Using pmcmd
17. Session parameters
18. Email Tasks
19. Command Tasks
20. Work Flow Monitoring
Should you require any further information please do not hesitate to contact us
Email id: trainings@keentechnologies.com
website URL:http://www.keentechnoligies.com
|
