EDUZZA

Informatica Level 2 Developer Course – (Advanced) Curriculum

Section 1: Data Warehouse Concepts
Introduction to Data warehouse
What is Data warehouse and why we need Data warehouse
Star schema/Snowflake schema/Galaxy schema
Dimensions / Facts tables.
Section 2: Introduction and Architecture
ETL (Extract-transform-load) Overview
Informatica PowerCenter as an ETL tool.
Architecture and Software Overview
Definition of Domain, Repositories, Integration Services.
Overview of Informatica PowerCenter Administration Console.
Section 3: Client Software Overview
Introduction to Designer Interface
Introduction to Workflow Manager Interface
Introduction to Workflow Monitor
Introduction to Repository Manager
Nature of ODBC in the Designer
Section 4: Source Object Definitions
Flat File Sources
Relational Sources
Data Previewer
LAB: Import a Source
LAB: Create a Source manually.
Section 5: Target Object Definitions
Target Definitions
Target Properties
Flat File Targets
Relational Targets
LAB: Import a Target
LAB: Create a Target, manually.
Section 6: Mappings
Defining a Data Flow Diagram
Transformation Objects and Views
Source Definition and Source Qualifier
Pre-SQL and Post-SQL Rules
Expression Transformation
Informatica Functions
Variable Ports
Data Types
Mapping Validation
LAB: Create a Working Mapping
Section 7: Workflows
Workflow Tools
Workflow Structure
Workflow Connections
Workflow Tasks
Workflow Design Process
Workflow Properties
Workflow Links
Session Tasks
LAB: Configure a Workflow and Session. And call previously created mapping.
LAB: Command line execution of a workflow.
Section 8: Monitoring Workflows
Workflow Monitor Views
Monitoring a Server
Actions Initiated from the Workflow Monitor
LAB: Run and Monitor the Workflow. View Logs and summary load information.
LAB: Demonstration of Designer Features
Section 9: Debugger
Debugger Features
9.2 Debugger Windows and Indicators
9.3 Debugger Best Practices
9.4 LAB: Debug a Mapping
Section 10: Transformation
What is a transformation in Informatica PowerCenter space?
10.2 Active and passive transformation
Section 11: Source Qualifier
Source Qualifier transformation Overview
Use of source qualifier to restrict data read from source.
Section 12: Expression Transformation
Expression Functionality
Use of a Variable port to hold previous row value.
Few common extression – IF-ELSE, ISNULL, etc
LAB: Create a Expression Transformation, Run Workflow
Section 13: Filter Transformation
Filter Functionality
Filter Properties
Filter Versus DB Where Clause
LAB: Create a Filter Transformation, Run Workflow
Section 14: Sorter Transformation
Sorter Functionality
Sorter Properties
Sorter Versus Database Order by Clause
LAB: Use Sorter transformation in a mapping
Section 15: Aggregator Transformation
Aggregator Transformation
Aggregator Expressions and Functions
Data Flow Rules
LAB : Use aggregator in a mapping.
Section 16: Joiner Transformation
Homogeneous and Heterogeneous Joins
Joiner Conditions and Properties
Joiner Usage
Types of Joins
LAB: Add Sorter, Joiner, and Aggregator
Section 17: Lookup Transformation
Lookup Principles
Lookup Properties
Lookup Caching
Lookup Versus Database Join
LAB: Create a Basic Lookup
Connected Lookup Vs Unconnected Lookup
Dynamic lookup transformation
Section 18: Unconnected Lookups
Usage and Techniques
Advantages
Functionality
Conditional Lookups
LAB: Create an Unconnected Lookup
Section 19: Update Strategy Transformation
Update Strategy Transformation
Update Strategy Expressions
Update Strategy Best Practices
LAB: Create a Type 2 Dimension Update
Section 20: Router Transformation
Router Functionality
Router Groups
LAB: Use a Router to Delete Rows
Section 21: Sequence Generator Transformation
Sequence Generator Functionality
Sequence Generator Properties
Sequence Generator Best Practices
LAB: Create a Sequence Generator transformation in mapping.
Section 22: Normalizer Transformation
Normalizer Transformation Functionality
LAB: Create a mapping which uses normalizer transformation.
Section 23: Union Transformation
Overview of Union Transformation
LAB: Create a mapping which uses union transformation.
Section 24: Parameters and Variables
Parameter Scoping
System Variables
Mapping Parameters and Variables
Variable Functions
Section 25: Mapplets
Mapplet Designer
Mapplet Advantages
Mapplet Types and Rules
Mapplet Parameters and Variables
Mapplet Designer Best Practices
LAB: Build a Mapplet
Section 26: Reusable Transformations
Transformation Developer
Rules
Transformation Developer Best Practices
LAB: Create and Use a Reusable Transformation
Section 27: Workflow Configuration
Server Connections
Reusable Workflow Schedules
Reusable Session Configurations
LAB: Create a Sequential Workflow
LAB: Create a Concurrent Workflow
Section 28: Reusable Tasks
The Command Task
Reusable Task Best Practices
Section 29: Non-Reusable Tasks
The Decision Task
The Assignment Task
The Timer Task
The Control Task
The Event Wait Task
The Event Raise Task
LAB: Create Event Wait/Event Raise and Timer
LAB: Create a Control and Assignment Task
LAB: Create a Command Line Task
Section 30: Worklets
Reusable Worklet
Non-Reusable Worklet
Worklet Best Practices
TAKE THIS COURSE
  • $999.00
  • 45 Days
  • Course Certificate

REVIEWS / TESTIMONIALS

  • Took the Salesforce dot com (SFDC) LIVE online course with Eduzza. Course instructor was very knowledgeable, and handled the class very well in terms...Read more

    Abhishek Kumar

    Business Analyst

  • My association with Eduzza began when I enrolled for the Oracle HFM (Hyperion Financial Management) course. Since I am a Business Analyst, I was a...Read more

    Gomesh Desai

    Business Analyst

  • I had a very good experience with the UI Web Development course which I took with Eduzza. Instructor paced the training according to my grasping of...Read more

    Israt Ali

    UI/UX Professional

  • I took the Business Analyst (BA) course from Eduzza. The best part about the course is that, variety of problems with real world use cases were...Read more

    Rakesh P

    Business Analyst

  • I had attended a couple of demo sessions in Advance Web Development with other training companies before joining EDUZZA. With EDUZZA's first demo...Read more

    Suvarna G

    Web Developer

  • First I will like to thank you for the C#.Net classes I'm currently taking; the instructor is wonderful, very easy to follow and understand. I feel...Read more

    Guisselle

    Software Developer

  • I was looking for a practical Business Analyst course and went through many other IT online training portals just when a friend of mine recommended...Read more

    Cong Nie

    Business Analyst

  • EDUZZA's Business Analyst Certification Training was indeed very good. The training sessions were very informative and clear. The trainer's own...Read more

    Deepali Pandit

    BA

  • Initially I was not sure about completing the Hadoop EcoSystem course in 30 hours but now I can say that EDUZZA's instructor Sitaram gave complete...Read more

    Chenna Manukonda

    Hadoop Developer

  • One of the best things about EDUZZA's "QA Training – Software Testing Course" online training is that it covers the practical aspects of the...Read more

    Paulomi Parekh

    QA Analyst

DISCOVER COURSES

Popular Courses