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 keyanatechnologies.com?

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