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