Informatica MDM Course

Ø  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

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

• 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.

All graduates and post graduates