Informatica real time online training by experts from usa


Processing your request, Please wait....

Additional Info

Contact Number/s8500122107
Coaching or Tuition Class Levelother classes
Classified Highlightsapex it online training , interview support , job support , online training by professionals , online training byexperts

Advertisement Description:

FOR FREE DEMO contact :

Email : [email protected]

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : [email protected]


Informatica Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


(the course content can be modified as per your requirements):

Introduction to data warehousing

Characteristics of data warehouse

How to design a data warehouse

Top down and Bottom up approach

What is a data mart

ETL fundamentals

Data Acquisition, Data Merging, Data Cleansing, Data Scrubbing, Data Aggregation

Dimensional Modeling (Dimensions, Facts)

Star Schema

Snowflake Schema

Slowly Changing Dimensions

PowerCenter Components

PowerCenter Client Tools

PowerCenter Designer

Workflow Manager

Workflow Monitor

Repository Manager

Excercise1: Pass-through Mapping

Working with source analyzer

Working with target designer

Working with mapping designer

Working with task developer

Working with workflow designer

Creating Data Source Names

Creating Relational Connections

Types of transformations (Active, Passive)

Excercise2: Expression Transformation Usage

Excercise3: Aggregator Transformation Usage

Excercise4: Filter Transformation Usage

Excercise5: Router Transformation Usage

Excercise6: Sorter Transformation Usage

Excercise7: Rank Transformation Usage

Excercise8: Joiner Transformation Usage

Excercise9: Union Transformation Usage

Excercise10: Lookup Transformation Usage (Connected, Unconnected)

Excercise11: Stored procedure Transformation Usage (Connected, Unconnected)

Excercise12: Sequence generator Transformation Usage

Excercise13: Update Strategy Transformation Usage

Excercise14: Source Qualifier Transformation Usage

Excercise15: Transactional control Transformation usage

Real time Mappings

SCD type-I

SCD type-II

Working with flat files

How to create flat file as target

How to read flat file data

File list (Working With Multiple Files)

Transformation Developer

How to create a reusable transformation

How to use reusable transformation in a mapping

Advantages of reusable transformations

Mapplet Designer

How to create a mapplet (reusable business logic)

How to use a mapplet in a mapping

Advantages of mapplets


How to work with command task

How to work with email task

How to work with session task

How to work with decision task

How to work with link task

How to work with timer task

How to work with control task

How to work with event-wait task

How to create reusable tasks

How to create non-reusable tasks


How to create parallel workflows

How to create sequential workflows

How to schedule workflows


How to create a worklet

How to use a worklet in a workflow

Nesting of worklets

Types of caches

Data Cache

Index Cache

Static Cache

Persistent Cache

Dynamic Cache

Working with functions

Performance Tuning

How to tune source

How to tune target

How to tune transformations

How to tune session

How to tune workflow

Informatica Realtime Scenarios

Copyright © 2018 Apex Online IT Trainings Inc. All Rights Reserved

Call us on : USA – +1 214 628 3894 | IND – +91 8500122107

for your course please follow the link :

Listing ID: 3155d987d707a824

Popular Ads Overall

Popular Ad Listing Tags

Advertising Afghanistan Algeria Antigua and Barbuda Argentina Armenia Ashmore and Cartier Island Associations Australia Austria Azerbaijan Bahrain Bangladesh Belgium Blogging Building Systems Burundi Business Opportunities Cambodia Cameroon Canada Caterers China Computer Consultancy Costa Rica Denmark Education Entertainment Finland Food France Georgia Germany Health Hong Kong Hotels India Indonesia Internet Iran Ireland Ireland Northern Israel Italy Japan Jersey Jordan Kenya Kuwait Latvia Lebanon Madagascar Malaysia Mexico Namibia Nepal Netherlands New York New Zealand Nigeria Norway Oman Pakistan Panama Peru Philippines Poland Power Products Publications Puerto Rico Qatar Romania Russia Saudi Arabia Singapore South Africa Spain sri lanka Sweden Switzerland Taiwan Thailand Tourism Trade show displays Training Transport Travel Turkey Uganda Ukraine United Arab Emirates United Kingdom Uruguay USA Classifieds USA United States Vatican City Vietnam Virgin Islands