India

+91 8447799888

USA

+1 (515) 442-2418

Informatica PowerCenter Certification Training Course

Checking...

Ouch! There was a server error.
Retry »

Sending message...

Enquiry Now


time-icon-vector-png_125592-removebg-preview

Course Duration

55 Days.

833px-PDF_file_icon.svg

Download Course Curriculum

ABOUT COURSE

Informatica PowerCenter Online Training is a widely used extraction, transformation and loading (ETL) tool used in building enterprise data warehouses. The components within Informatica PowerCenter Courses aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse. Informatica PowerCenter is produced by Informatica Corp.

Informatica PowerCenter Certification provides reliable solutions to the IT management, global IT teams, developers and business analysts as it delivers not only data that can be trusted and guarantees to meet analytical and operational requirements of the business, but also offers support to various data integration projects and collaboration between the business and IT across the globe.

Benefits of Attending Informatica PowerCenter Training

Why Kasha Training Education?

Feedback from our Participants

COURSE CURRICULUM

  • Overview
  • Basic Definitions
  • Informatica products
  • Informatica Architecture
  • Folders-Sub folders
  • ETL Tools and their roles
  • ETL information power center / Power mart
  •  
  • Data warehousing (what is Data warehousing /Why Data warehousing/How Data warehousing)
  • Slowly Changing Dimensions (SCD1, SCD2, SCD3)
  • Metadata
  • Dimensional Table
  • Types Of Dim Tables
  • Fact Table
  • Types of Fact Tables
  • OLTP (Online Transaction Processing)
  • OLAP (Online Analysis And Processing)
  • OLTP Vs OLAP
  • Advantages of OLAP
  • Different Methodologies of DWH
  •  
  • Informatica configuration
  • Instigation Services
  • ETL Folder
  • ETL Job Filz
  •  
  • Introduction to Designer
  • Logon to Designer
  • Designer interfaces
  • Designer Tools
  • Defining Sources
  • Database as a source
  • Flat File sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database objects
  •  
  • Aggregate Transformation
  • Shorter Transformation
  • Active and Passive Transformations
  • How Sequencer work and Uses of Sequencer Transformation
  • Filter Transformation
  • Lookup transformation
  • Connected lookup
  • Unconnected lookup
  • Joiner Transformation
  • Filter Transformation
  • Ranking Transformation
  • Router Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Stored Procedure Transformation(Connected and Unconnected)
  • Union Transformation
  • XML Transformation
  •  
  • Mapping Introduction
  • Ports
  • Mapping – Table to Table
  • Mapping Flat File to Table
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III Mappings
  •  
  • Source Qualifier Transformation
  • SQL override in source qualifier transformation
  • Source qualifier transformation joins concept
  • Source qualifier transformation on Relational Databases
  • Source qualifier transformation on File systems
  • Source qualifier transformation filter concepts
  • Difference Between SQL Override, Other Options
  • Source Qualifier to join Data
  • Source Qualifier Transformation Performance Tunning
  • Pre SQL and Post in Source Qualifier Transformation
  •  
  • Workflow Introduction
  • Tasks
  • Workflow tools
  • Connections
  • Defining tasks
  • Command Tasks
  • Email Task
  • Session Task
  • Link Conditions
  • Event Wait & Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
  •  
  • Incremental Aggregation
  • Mapplet Implementation
  • Target Load Plan
  • Constraint Based Loading
  • Mapping Variable
  • Session Parameters
  • Link Conditions
  • Reusable Transformation
  • Task and Types of Tasks
  • Work let and Types of work lets
  • Scheduling Workflow
  • Control flow using Command task and event wait task
  • Incremental Loading
  •  

WHO CAN LEARN?

FAQ

Most frequent questions and answers

Click on Enquire now and register.

Yes we do provide Demo session and one free class that will help you to decide.

Yes all relevant material would be provided.

Yes all relevant material would be provided.

About Us

Kasha Training is one of the world’s leading Online training providers, helping professionals across industries and sectors develop new expertise and bridge their skill gap for recognition and growth in the corporate world.

Copyright © 2021 Kasha Training. All Rights Reserved

Need Help? Chat with us