Informatica ETL Training
Training Mode - Class Room / On Line.
- Class Room / On Line Session.
- Class Room : Small Batch Size.
- Online : Individual.
- Practical Project Based.
- Experienced Trainer.
- 80 hrs Video Tutorials.
- 24 hrs On Line Support.
- Links to Download Examples.
- Assignments Links.
- Placement Support.
- Flexible Timings.
About Course : We have launched Informatica ETL Powercenter course designed by Experienced ETL Developers for Candidates who want to make career in Dataware Housing, Business Data Analysing and Business Data Development. Training is 100% Practical Project based in which we start from basics and gradually move to Advance level covering complete Powercenter ETL Development with Unix Commands and PL/SQL. All our Trainers are B. Tech / MCA with 5+ years of expert knowledge.
What you will Learn :
Informatica Development
Introduction to Data warehousing
- Overview of a DWH
- Need of a data warehouse
- Data warehouse layer architecture
- OLTP/Transactional system and OLAP
- Meta Data, Granularity, Data Mart
- Design approach Top down/Bottom up
- Designing a warehouse using Star/Snowflake schemas
- Dimension
- Fact
- CDC approach
Introduction to Informatica/ETL tools
- The role of ETL tools in data warehousing
- An introduction to Informatica
- Informatica Architecture
- Components/Process flow
Informatica Designer
- Basic Concepts
- Using the designer
- Working with the Sources-Source Analyzer
- Working with Relational/Flat file targets- Warehouse Designer
- Defining Keys in Informatica
- Working with Transformations –Transformation Developer
- Working with Mapplets- Mapplet designer
- Creating mappings –Mapping Designer
- Understanding Pipelines in mappings
- Setting Target Load order
- Configuring Constraint Based loading
- Introduction to Mapping Parameters/Variables
- Implementing Type1, Type2, and Type3 Mappings
Working with Transformations
- Active/Passive Transformations
- Connected/Unconnected Transformation
- Importance of Source Qualifier
- Filter, Router
- Expression
- Sorter, Aggregator
- Rank
- Joiner
- Lookup
- SQL
- Stored Procedure
- Sequence generator
- Union
- Update Strategy
- Xml transformation
Creating Workflows
- Understanding the server Architecture
- Working with Workflows
- Working with Tasks Assignment,Command,Decision,Control,Event raise,
- Event Wait,Timer,Email,Session Task
- Working with Work lets
- Working with Sessions
- Understanding Commit Points
- Recovering Data
- Monitoring Work flows
- Using Multiple Servers
- Log files
- Row Error Logging
- Session parameters
- Parameter files
- Using Incremental Aggregation
Basic oracle and unix only for interview point of view
Mini project
Interview question and scenario
Google Map - Locate Us
Gallery
