Informatica Online Training

Informatica

Batches coming soon...

About Informatica Online Training

Informatica is essentially used to harbour the task of data (extraction) from a source and then to load the requisite data soon after it has been modified or transformed for further processing. Informatica is essential to enhance the efficiency of any business enterprise.

Course highlights/Objectives:

The learners are provided with best video sessions for better understanding of concepts. The trainers offer the study materials with clear illustration of real time business problems and their solutions. We provide an optimized learning process/experience which is economical.

Who can Learn this course?

Anyone who has prior/basic knowledge in Data Warehousing technologies can opt for this course. Any of the Graduates/Post Graduates are eligible.

Prerequisites:

Any of the technical background consultants are eligible.

Why Informatica?

Informatica is an Engine driven ETL tool which is mostly used in Data warehouse environment and Data Integration. It is supported in different environments like WINDOWS, UNIX, and MAINFRAME

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

Reviews

Not reviewed yet


Enquiry Form