All for Joomla All for Webmasters

Informatica

informatica

This course is expected to take one and half months with total 12 classes, each class is having three-four hours training. It can take lesser time if the number of hours per day is increased.

About the Course

No pre requisite required for the classes . Appreciate to have the basic knowledge of UNIX OS

1. Start right from the Informatica installation. 

2. 100% Practicals approach to solve the problem statement than theoritical. 

3. All study materials included in the course fee

4. Completion Certification after the training.

5. Live projects and development.

Syllabus

Introduction of Informatica.

• Advantages of Informatica compared with different coding technologies.
• What us ETL? i.e .Extraction, Transformation and loading
• Informatica Architecture.
• Informatica Components i.e. Server, Client, Server Components

Add On

• Informatica cd.
• Informatica Installation.
• Basics of Unix Commands.
• Basic Unix Shell scripting.
• Basics of Dataware house training.
• Data Mart and Data Modeling.
• Star Schema and Snow Flake Schema.
• Types of Facts and Fact Tables.
• Types of Dimensions.

Module 1

• Services provided by Informatica
• Integration Service.
• Repository Service.
• Reader & Writer DTM.

Module 2

• Designer.
• Workflow Manager.
• Monitor.
• Repository Manager.
• Transformations

Module 3

• Router and Joiner
• Expression Transformation
• Rank Transformation
• Sorter Transformation
• Aggregator Transformation
• Lookup Transformation
• Union T/F

Module 4

• Normalizer transformation.
• Update strategy.
• Sequence Generator transformation.
• Transaction control.
• SQL Transformation.
• Non reusable transformations.
• Reusable transformations.
• Power center workflow manager

Module 5

• Workflow Tools.
• Workflow Structure and configuration.
• Workflow Tasks.
• Workflow Design and properties.
• Advanced topics

 Module 6

• Normal Load & Bulk Load.
• Incremental Load.
• CBL Loading.
• Target Load Ordering.
• Dynamic Lookups.
• SCD types, 1,2,3.
• Mapplets & Worklets.
• Limitations of Mapplets.
• Pushdown Optimization.
• Unit Testing.
• Export and import of objects

Module 7

• Debugger
• Versioning
• Parameters & variables
• Enable Test load
• Commit Types
• Over View PMCMD & PMREP Commands
• Pre SQL’s and Post SQL’s
• Target Over ride
• PC workflow tasks

Module 8

• Session
• Email Task
• Command task
• Control Task
• Timer Task
• Worklet
• Decision Task
• Event Wait
• Event Raise
• Assignment task
• Link Conditions

Module 9

• Concurrent and sequential Workflows
• Concurrent Workflows.
• Sequential Workflows.
• Stopping, Starting and suspending tasks and workflows
• Scheduling of workflows.
• Performance Tuning

Module 10

• Overview of System Environment.
• Identifying Bottlenecks .
• Source Level
• Target Level
• Mapping Level
• Data Base level
• Data Warehouse Concepts

Contact Us

Solitaire Residency Gate,
Above Honda Showroom,
Rahatani Rd, Ahead of Konkane Chowk,
Pimple Saudagar, Pune

Email: training@ethans.co.in
Phone: +91 8698585003 / 020-46741224
Webiste www.ethans.co.in

feedback