Informatica Training in Chennai
Informatica Is Most Powerful ETL Tool. Extraction, Transformation, And Load.Informatica Is Simple User Interface Like Visual Basic. Informatica Is Data Integration Tools In Different Platform. It’s Just Drag And Drops The Object. User Can Use Different Type Of Sources like Database’s Teradata, Sqlserver, Oracle, Db2 Files Are XML, Cobol, Flat File To Extract The Data And Use Transformation To Transfer The Data And Load To Any Of The Same Format Like Databases, Files.Its Move To Large data Are Move To Productive Way
Fill This Form For Demo Class
About Course
This Course Gives You A Informatica Development, Understanding About How To Use Informatica Power Center 9.X. A Real Time Scenario And That Will Use Informatica To Create, Transformations, Load, Execute And Schedule Informatica Process. We Customized This Course Curriculum To Meet The Current Industry Standards.
Course objectives
At End Of This Informatica Training By Htop, You Will Be Able To,
- Describe Data Warehouse Architecture
- Describe Data Informatica Architecture & Components
- Learn How To Work With Database, XML, Cobol In Informatica
- Use Informatica Component To Assemble Mappings, Task, Workflows
- Learn About Informatica Transformation Types
- Execute Performance Tuning And Optimization
- Perform Debugging And Error Handling And Recovery
- Handle Workflow Tasks And Scheduling
- Learn SCD Types(Type 1,Type 2,Type 3)
Who can learn this course?
This Training Will Be Suitable For,
- Fresh Graduates
- Job Seekers
- IT Professionals
Job Opportunity
ETL-Informatica Tools An Endless Technology Which Is Used By It Companies Day-By-Day. So Learning Informatica Will Open Lot More Opportunities In The Stat Up Company’s Also
Course Duration Information
This Informatica Training Will Be Happen For 25-30 Hours. If You Opt For Weekend Classes Both Saturday And Sunday You Will Be Having Approximately 2 Hours 30 Mins In Scheduled Time Of The Batch You Chose. If You Opt For Weekdays Classes All Monday To Friday You Need To Spend At-Least 1hr 30 mints.
Course Syllabus
Introduction To Data Warehouse
- What Is Data Warehouse?
- Data Warehouse Architecture
- Explain OLTP, OLAP
- Explain Schemas
First Steps
- What Is Etl?
- What Is Informatica?
- Informatica Architecture Overview
- Explain Informatica Power Center Components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
- Power Center Admin Console
Sources
- Relational Sources(Data Bases)
- Files Sources(Flat File, XML, Cobol)
Targets
- Relational Targets(Data Bases)
- Files Targets
Transformations
- What Is Transformation
- Type Of Transformation
- Active Transformations
- Passive Transformations
- Expression Transformation
- Filter Transformation
- Router Transformation
- Sorter Transformation
- Rank Transformation
- Source Qualifier Transformation
- Aggregator Transformation
- Joiner Transformation
- Sequence Generator Transformation
- SQL Transformation
- Stored Procedure Transformation
- Lookup(Different Type Of Lookup) Transformation
- Union Transformation
- Normalizer Transformation
- Update Strategy Transformation
- Slowly Changing Dimension
- SCD Type-1
- SCD Type-2(Date, Flag, And Version)
- SCD Type-3
Workflow Manager
- Create Reusable Tasks
- Workflows, Sessions, And Worklets
- Task
- Session
- Decision Task
- Control Task
- Event Wait Task
- Timer Task
- Monitoring Workflows And Debugging Errors
Indirect Loading
Constraint-Based Load Ordering
Target Load Plan
Worklet, Mapplet
Reusable Transformation
Migration
- XML Migration & Folder Copy
Scheduling Workflow
Parameter and Variables
XML Source, Target, and Transformations
Performance Tuning
Partition
Good place to learn selenium. Found them online and joined classroom training. Trainers are experienced working professionals, explained all syllabus and nice environment to learn
Gayathri Kumar