Why This Course

Informatica : A Leader in Entreprise ETL – Forrester Research

Informatica professionals earn upto $130,000 per year – Indeed.com salary data

GE, eBay, PayPal, FedEx, EMC, Siemens, BNY Mellon & other top Fortune 500 companies use Informatica.

More than 350+ Satisfied learners. Know about their learning experience


Training Strategy

Instructor Live Online Sessions – Provides real-time interaction with the instructor and learners as per their respective time zones.                            

Support – Our expert trainers are willing to support you even after completion of your training. This will make you more confident to work for an organization

i

Real-time Case Studies – Based on an in-depth investigation of a professional, group or event to explore the causes of underlying principles, which are helpful to master you in your course

Certification – Learner, who completed their training with eTrainingsIndia will get a softcopy of training certificate stating that particular learner trained with eTrainingsIndia.


Course Curriculum

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 Data Masking

Data Unstructured 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

Sample project development:

Star Schema Design with Dimension Tables and fact table.

Benefits of Star Schema

Overview on foreign keys and candidate key

Design a complex workflow for sample project



Frequently Asked Questions

Can I Attend a Demo Session Before Enrolment ?

We have limited participants or only one participant in a live session to maintain the quality standards. Se we provide  demonstration session before enrolment. However, without attending demonstration learner couldn’t able to clear his technical doubts about his desired technology. So we always recommend a learner to attend a demonstration with the person who will deliver the classes.


 Who is the instructor at eTrainingsIndia ?

All the instructors at eTrainingsIndia are experts from the industry with minimum 9-12 years of relevant IT experience. They are subject matter experts for providing an awesome learning experience.


 What if I miss a class ?

You will never lose any session. You can choose either of the two options:

  • Ask for a recorded session of the class from your instructor.
  • You can attend the missed session, in any other live session by the same instructor.
  • Prior update or intimation is needed if you are not attending the session

 Will I Get Placement Assistance ?

eTrainingsIndia is committed to giving you an adorable learning experience through our live online training and expert instructors. Through our training we will enable you to convert opportunities into job offers by presenting your skills at your interview. We can assist you in resume building. Please understand that we are not into placement services.


 What If I have more queries ?

Feel free to reach us at +91 9010769088 or mail us at contact@etrainingsindia.com