Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in Informatica
Course Duration | 25 hrs | ||
---|---|---|---|
Live Projects | 2 | ||
Next Batch | 17 April, 2021 |
Basic Definitions
Informatica Products
Informatica Architecture
Tools and their roles
Folders -subFolders
Power Center I Power Malt
Introduction to designer
Designer interfaces
Designer tools
Defining Sources
Database as a source
Rat Flies sources
Defining Targets
Importing from database
Creating a new target
Creating target database objects
Mapping Introduction
Informatica Designer
Ports
Mapping -Table to Table
Mapping flat File to Table
Connected/Unconnected Transformations
Active and Passive Transformation
Source Qualifier Transformation
SQL Override-Source Qualifier Transformation
Source qualifier to join Data
Filter Transformation
Expression Transformation
Sequence Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored procedure Transformation (Connected & Unconnected)
Union Transformation
XML Transformation
Mapping Wizards
Implementing Type-I, Type-II, Type-III
Mappings
Workflow Introduction
Workflow tools
Connections
Defining tasks
Command Task
Email Task
Session Task
Link Conditions
Event Wait & Event Raise
Creating Workflow
Starting Workflow
Monitoring Workflow
Incremental Aggregation
Mapplet Implementation
Target Load Plan
Constraint-based Loading
Mapping Parameters
Mapping Variables
Upon the course completion, the students can:
Tekslate Informatica training is designed by experts to make you a Certified Informatica Administrator and Informatica Developer. This Informatica Certification course offers:
Introduction of Informatica basics.
Learn about the data warehousing concepts
How the Dimension tables used and OLAP
Learn PowerCenter components
Informatica Architecture
Learn about source qualifiers
Look Caching and techniques
Worklets tasks
Advanced concepts on Informatica V10.
Informatica is the leading and unique data integration platform with an unbiased and universal view. It is the powerful data transformation tool and is the on-demand application to transfer data from one format to another. Due to its increasing demand, the job opportunities for Informatica professionals are increasing around the globe. On average, the certified Informatica administrators earn $159,518 per annum.
ETL & SQL Developers and Business Intelligence Professionals
Database & Mainframe Professionals, Project Managers
There are no specific prerequisites for learning Informatica. Having basic SQL knowledge is an added advantage.
We will provide two real-time projects under the guidance of a professional trainer, who will explain to you how to acquire in-depth knowledge on all the concepts involved in these projects.
Have More Questions
Contact usHave questions? We’ve got the answers. Get the details on how you can grow in this course.
Have More Questions. Reach our Support Team
Contact usSee if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate
Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in Informatica
By providing us with your details, We wont spam your inbox.