Informatica MDM Course

Informatica Developer Tool- Informatics developer was developed by Informatica Corporation in the year 1993. This company is well known for data integration product Power Centre. Informatics Developer is a tool where data quality plans or maps are developed. It is a software development kit (SDK) with set of API’s to extend the functionality of power centre platform. Informatica tool contains all the transformation of power centre related to data quality.

Batch details of live online classes

Starting Date Timings Ending Date
Wed Oct 2020 2PM - 4PM Tue Nov 2020

Course Price at



Topics Covered


Ø  Introduction to ETL Logic

Ø  Overview of Staging Area

Ø  Need of ETL Logic

Ø  Difference between OLTP systems and OLAP systems

Ø  Overview on Data Warehousing concepts

Ø  Introduction to Data Modeling

Ø  Overview on Database

Ø  Construction of DWH/Data marts using ETL logic

Ø  Introduction to Informatica Power Center

Ø  Difference between various versions of Power center

Ø  Overview of sub tools of the Informatica Power Center:

  • Informatica Client
  • Informatica Server
  • Informatica Repository
  • Informatica Repository server
  • Overview on integration service
  • Internal Architecture of the server

Ø  Informatica client:

  • Informatica designer
  • Workflow manager
  • Workflow monitor
  • Repository manager
  • Repository server administrative console

Ø  Working with Power center administrative console

  • Create a folder
  • Create a repository service
  • Create an integration service
  • Create users and users groups and assign privileges
  • Working with logs
  • Explanation on data movement mode

               ASCII and Unicode

Ø  Informatica Designer:

  • Source analyzer
  • Ware house designer/ target designer
  • Transformation developer
  • Mapplet designer

·        Mapping designer

Ø  Workflow manager:

  • Workflow designer
  • Worklett designer
  • Task developer

Ø  Transformations:

  • Reusable transformations
  • Non-reusable transformations
  • Active and Passive transformations

1)     Source qualifier

2)     Expression

3)     Aggregator

4)     Rank

5)     Filter

6)     Router

7)     Lookup

a)      Connected

b)     Unconnected

c)      Difference between Dynamic Lookup, Static Lookup, Persistence Lookup

And Re-cache from the source

8)     Stored Procedure and function

a)      Connected

b)     Unconnected

9)      Update Strategy

10)  Transaction control

11)  Normalizer

12)  Sequence generator

13)  Union

14)  Joiner ( Normal, Master outer, detail Outer, Full Outer)

15) XML Source qualifier

16) Sorter

17) Mapplet input

18) Mapplet Output

Ø  Advanced Transformations:

Java Transformation

Sql Transformation

HTTP transformation

SAP R/3 Transformation

Mapping designer:

Ø  Best practices when building mappings

Ø  Construction of complex  mappings for dimension tables and fact tables

Ø  Dimension mappings:

  • SCD type-1
  • SCD type-2
  • Flag current data
  • Effective data range
  • Version number mapping
  • SCD type-3
  • Design type-1, type-2, and type-3 dimensions for various requirements within a single mapping

(Hybrid Dimension-HSCD).

  • Working with rapidly changing dimensions (Monster Dimensions)

·        Construction of the complex mappings for Data warehousing

·        Creation of the cubes

·        Analysis of Business user requirements

Ø  Combined type-1,type-2 and type-3 in a single mapping

Ø  Working with SCD wizards

Ø  Working with Rapidly Changing dimensions (RCD).

Ø  Development of the target tables based on business user requirements

Ø  Source analyzer:

  • Import source tables from different data bases or flat files
  • Working with XML files
  • Working with COBOL files
  • Create new source tables in the sources analyzer
  • Define the relationships
  • Create source tables in source analyzer itself.

Ø  Target designer:

  • Import target tables from different data bases or flat files
  • Create target tables in target designer itself.
  • Reusable transformations in Transformation developer
  • Transformation logic development in Mapplet designer
  • Properties explanation of the transformations
  • Customized query generation in source qualifier
  • Pre and post sql

Ø  Differences between source qualifier and joiner transformation with practical explanation

Ø  Difference between filter and router transformations with practical explanation

Ø  Difference between expression and aggregator transformation with practical explanation

Ø  Overview of the workflow manager

  • Reusable tasks development in task developer
  • Tasks logic development in worklett designer
  • Workflow development in workflow designer
  • Design sequential and concurrent batch workflow

Ø  Explanation of the different types of the memories

·        Buffer, Cache

Ø  Overview of the load manager

Ø  Overview of the Data transformation manager

Ø  Overview of different types of tasks:

  • Start task
  • Session task
  • Event wait
  • Event raise
  • Timer
  • Decision task
  • Control task
  • E-mail task
  • Command task
  • Mapping parameters and variables creation
  • Parameter file creation
  • Internal working function of the Informatica Power center
  • Parallel Pipeline partitioning
  • Creation and deletion of partitioning points

Ø  Execution of the mappings:

  • Normal execution
  • Debugging mode execution

Ø  Loading:

  • Normal loading
  • Bulk loading
  • Constraint based loading

Ø  Lookup cache:

  • Static
  • Dynamic
  • Re-cache from source
  • Persistent cache
  • Shared cache

Ø  Introduction to Load Manager (LM)

Ø  Overview on DTM (Data Transformation Manger)

Ø  Working with Parallel pipeline partitioning mechanism:

Source level, transformations level and target level.

Ø  Introduction Threads

Ø  Types of threads:

·        Reader thread

·        Transformation thread

·        Writer thread

·        Pre-session thread

·        Post-session thread

Ø  Analysis of BRS

Ø  Development of RRS


  • Create a Model Repository service
  • Create a Data Integration service
  • Download and Install appropriate version of Informatica Developer platform tool that matches your PowerCentre version from Informatica Communities website.


What are the objectives?

Informatica developer replaces the traditional Informatica data quality.

  • Helps you to create and understand basic mappings (moving data from inputs and outputs), basic objects and export procedures
  • Helps to observe the load process and analyze results for knowing the success ratio
  • Meet out the connectivity requirements to get data from different sources
  • Helps you to profile your data, create score cards and address validation

Why to Learn this course?

  • Open ended system

Informatica is a open ended system that supports multiple platforms and multiple data management environment.

  • Metadata repository

Informatica sessions can be arranged in folders based on the worklets and work flows. This leads to an environment which is easy to maintain and quicker to analyze and enhance

 Popular Course in this category


  • Universal connectivity to data sources

This tool enables easy access and cleansing of any type of data from any source and in any mode within the enterprise or in partner’s system or in the cloud or in Hadoop.

  • Flexibility

Informatica is an independent player to solve to solve customers’ problems. There is no proprietary system to protect and no set of standards to impose. It offers you the choice to choose what works best for your environment.

  • Job monitoring and recovery

Informatica lets you to monitor the jobs easily by means of Informatica Workflow Monitor. It also lets you restart failure jobs from particular row or step. Informatica also lets you discover and recover the failed jobs

  • Informatica Marketplace

Informatica market place contains lot of tools and accelerators to improve the application support

  • Supports various platforms

Informatica acts as connectors to various databases including Teradata mLoad, tPump, FastLoad and Parallel Transporter.

There are also few connectors for which you need to invest an extra cost. One example of such source is social media sites like Facebook, Twitter, and others.

  • Shareable bookmarks and notes

Informatica enables its team members and business to share the data profiles and quality cards easily through bookmarks and providing comments in notes section.

  • Market leader

Informatica is the market’s leading data integration platform. It provides to its customers what they want and a data integration solution that can integrate with more data from various sources and in a very minimum time and effort.

  • Innovative

Informatica is known for its innovation. Its data integration platform is developed to meet the challenging data integration requirements. It has a architectural approach and has a consistent record of delivering solid technologies to its customers. Thus it attracts many customers.

  • Industry Leading Support

Informatica has developed a support organization which offers superior service. The support team has developed a clear set of rules and procedures to approach a problem and find a solution for that. The support system has a centralized call logging and tracking system that will help in arranging the issues based on its priority and severity.

Who should go for this training?

All graduates and post graduates

Additional Data

Advantages of Informatica

  • Informatica is a tool that acts as a single platform for data quality
  • It helps in improving the data analyzing, profiling, validating and cleansing data
  • This tool enhances the productivity of the business through its IT collaboration tools and data quality development environment
  • It helps you connect with all the data sources located widely
  • It reduces the license and maintenance costs
  • Supports multiple projects and project types
  • This tool helps you to develop address standardizations, exception handling and data masking. It also integrates all these with PowerCentre to make use of them as components or mapplets
  • It helps to identify, solve and prevent data quality problems
  • It supports each and every role of data integration projects like data stewards, data analysts, architects and developers
  • Informatica offers effective data profiling and effective ways to share the results of your business
  • Through this tool data becomes more trusted
  • Informatica contains centralized data quality rules for all applications
  • All the reference data can be again used for all types of data integration projects such as data migration, data consolidation and MDM
  • It meets out the four basic needs of the customers – Need to be comprehensive, Need to be open, Need to be unified and Need to be economical
  • It offers whatever you need related to data integration like data quality, data migration, data archiving, data consolidation, data synchronization and many others
  • Informatica works with your existing systems, application and technology standards
  • Lower maintenance costs, more stable operations and faster response to business conditions
  • Achieve better business outcome and maximize the return on data
© 2020 eitcafe. All rights Reserved.