Informatica Online Training

Informatica Online Course Summary

This online course is been designed by Informatica course Experts to enhance and expertise the skill set of Informatica (tool) and our expertise professionals train the learners to become the successful Informatica developer.

The topics covered under this course are as follows:

Data ware housing Concepts:

Introduction/ what /Why/How Data ware housing)

• Slowly Changing Dimensions

• Metadata

• Table- Dimensions

• Types Of Dim Tables

• Fact Table

• Different Types of Fact Tables

• OLTP

• OLAP

• OLTP Vs OLAP

• OLAP - Advantages

• DWH -Different Methodologies.

PowerCenter Components and User Interface

• Informatica Architecture(PowerCenter)

• Informatica Client Tools(PowerCenter)

• Start Using of the Designer, Workflow Monitor, Workflow Manager

Source Qualifier

• Source Qualifier Transformation

• SQL override in source qualifier transformation

• Source qualifier transformation – concept (joins)

• Source qualifier transformation - Relational Databases

• Source qualifier transformation - File systems

• Source qualifier transformation - filter concepts

• Differences between Other Options and SQL Override

• Source Qualifier Transformations- Performance Tunning

• Post and Pre SQL - Source Qualifier Transformation

Expression, Filter, File Lists and Workflow Scheduler

• Expression Editor

• File Lists

• Workflow Scheduler

• Filter Transformation

Joins, Features and Techniques

• Shortcuts

• Joiner Transformation

Lookups and Reusable Transformations

• Lookup- Transformation

• Reusable -Transformations

Debugger

• Debugging Mappings

Sequence Generator

• Sequence Generator- Transformation

More Features and Techniques, Lookup Caching

• Lookup Caching

Router, update Strategy and Overrides

• Router Transformation

• Transformation of Update Strategy

• Target Override

• Expression Default Values

• Source Qualifier- Override

• Session Task Mapping Overrides

Error Logging and Dynamic Lookup:

• Dynamic Lookup

• Error Logging

Unconnected Lookup, Parameters and Variables

• Lookup Transformation (Unconnected)

• System Variables

• Mapping Variables & Parameters

Sorter, Aggregator and Self-Join

• Sorter Transformation

• Self-Join

• Aggregator -Transformation

• Active and Passive -Transformations

• Data Concatenation

Mapplets

• Mapplets

Workflow Variables and Tasks

• Link Conditions

• Variables Workflow

• Email Task

• Assignment Task

• Decision Task

More Tasks and Re-usability

• Event Raise Task

• Command Task

• Event Wait Task

• Reusable Session Task

• Reusable Tasks

• Reusable Session -Configuration

Worklets and More Tasks

• Worklets

• Control Task

• Timer Task

Frequently Asked Questions