+1 (540) 707-5859

contactus@vrpcorpsolutions.com

Informatica Online Training

ABOUT THE COURSE
Course Duration

30 hours of training with two convenient options (weekday or weekend sessions)

Training Materials
  • Comprehensively designed course material by expert team of professionals with four years of experience in online and corporate training
  • Live session practice and recorded sessions
  • 24*7 access to the systems and servers
  • Get instant feedback on the work through assessments, quizzes and tests
What’s Needed To Join This Course?

A candidate who wishes to enroll for this course must have a basic knowledge of ETL, SQL and Data warehousing concepts.

Who Are Ideal Candidates?

This course can be pursued by any graduate, fresher, working professional, software developer with basic knowledge of SQL and fundamentals of data warehouse.

Course Info

This training course is designed to avail the services of Informatica in the form of an ETL tool to extract the data from the source location and load it to the destination after required transformation. Course contents of this online training course are Data Warehousing Introduction, Client Software Overview, Source and Target Object Definitions, Mappings, Monitoring Workflows, Debugger, Filter/Sorter/Aggregator/Joiner/Lookup Transformation, Parameters and Variables, Sequence Generator Transformation, Workflow Configuration and Worklets.

Why VRP CORP SOLUTIONS?

Our institute has a strong and committed team of professionals who not only aim at developing skill set of a candidate but also confidence, interpersonal skills and analytical skills which are greatly required to successfully perform at the workplace. Some of our outstanding features include:

  • Quality theoretical lectures with extensive practical exposure on advanced set of tools and technologies
  • Offer daily and weekend classes to suit the convenience and availability of the students
  • Assurance of 100% satisfaction
  • 100% Placement assistance on successful completion of the course
ABOUT THE COURSE

CURRICULUM

Introduction and Architecture
Introduction to Informatica
  • Architecture of Informatica — Power Center 8.1
  • Informatica Design Process
  • Informatica Client Tool — Designer
  • Source Analyzer and Warehouse Designer
Mapping Designer
  • Create a Simple Mapping
  • Overview of Transformations
  • Types of Transformations — Active and Passive
  • Expression Transformation
  • Source Qualifier Transformation
  • Introduction to Workflow Manager
  • Control Flow Statements
  • Task Developer
  • Workflow Designer
  • Creating Connections
  • Flat Files Handling
  • Create Simple Mappings
  • Flat File Analysis
Architecture Review
  • Architecture 8.1 Review
  • Differences between Power Mart and Power Center
  • Connecting to SAP
  • FTP Process
  • Command Task
  • Create a Mapping
  • Joiner Transformation
Transformations
  • Create a Mapping
  • Using Join in a Source Qualifier Transformation
  • Expression Transformation
  • Filter Transformation
  • Transformations Contd
Multiple Targets Loading
  • Router Transformation
  • Diff between Filter and Router Transformations
  • Create a Mapping
  • Master Outer Join
Transformations Contd
  • Create a Mapping
  • CReusable Transformation
  • CLookup Transformation
  • CDebugger
  • CHandling Multiple Files as Source
  • CMapplets
  • CCreate Mappings
  • CSequence Generator Transformation
  • Multiple Pipelines in a Single Mapping
  • Target Load Plan
  • Mapplets
Update Strategy
  • SCD Type 1 mapping Implementation
  • Update Strategy Transformation
  • SCD Type 2
  • SCD Type 2 mapping Implementation
  • Loading Strategy
  • Sequential and Parallel Loading
  • Union Transformation
  • Dynamic Lookup Cache
  • Introduction to Fact Loading
  • Create a Mapping
Transformations Contd
  • Create a Mapping
  • Date Dimension Loading
  • Lookup Transformation – Persistent Cache
  • Aggregator Transformation
  • Sorter Transformation
  • Creating Stored Procedure
Transformations Contd
  • Normalizer Transformation
  • Stored Procedure Transformation
  • Active Vs Passive Transformations
  • Connected Vs Unconnected Transformations
Implementing Incremental Loading
  • Create a Mapping
  • Importance of Mapping Variable
  • Implementing Incremental Aggregation
  • Create a Mapping
  • Incremental Aggregation
  • Transaction and Variable Port
  • Transaction Control Transformation
  • Variable Ports
  • Workflow Tasks
  • Scheduling
  • Task Link Properties
  • Event Raise Task
  • Event Wait Task
  • Work let

Others
Parameter Files
Removing Duplicate Rows