Inara Technologies | Informatica Training
page,page-id-17080,page-template-default,ajax_fade,page_not_loaded,, vertical_menu_transparency vertical_menu_transparency_on,qode-theme-ver-7.2,wpb-js-composer js-comp-ver-4.5.1,vc_responsive

Informatica Training introduces learners to advanced learning of Informatica Installation, Configuration and Administration using PowerCenter 9.X. This course gives an exposure to using automated, scalable and auditable approach to test and monitor critical data processing. It also covers Workflow Informatica, Manager and Monitor, Repository Management and deployment of strategies like creating transformations, session, mappings, performance tuning and others.

Course Benefits:

Syllabus: We came up with a unique list of topics that will help you gradually work your way into the testing world.

Practice sessions: Assignments in a way that you will get to apply the theory you learnt immediately.

Video sessions of Instructor led live training sessions.

Practical learning experiencee with live project work and examples.

Support: Our Team is going to be available to you via email or the website for you to reach out to us.

Learn SQL Server basics from a professional trainer from your own desk.

Information packed practical training starting from basics to advanced testing techniques.

Best suitable for beginners to advanced level users and who learn faster when demonstrated.

What are the requirements?

  • Anyone with basic computer knowledge can take this course.

What am I going to get from this course?

  • Understand PowerCenter Workflow Manager
  • Understand Workflow Task and Job Handling
  • Use Session Parameters, Workflow Variables in PowerCenter
  • Perform debugging, troubleshooting, Error Handling and Recovery in PowerCenter
  • Understand and implement session caches
  • Gain insights into Performance Tuning and Optimization
  • Understand Informatica Administration Console and Security
  • Define Technical Architecture of Informatica 9.X
  • Learn Informatica Installation and Configuration
  • Learn to handle ETL scenarios and understand functionalities of Repository Management
  • Understand Informatica Error Handling framework
  • Use SQL Transformations, XML Transformations and Perform XML processing and Push Down Optimization 

Informatica Course Syllabus

Module 1 : SQL

Introduction To Database:
Importance of SQL in Informatica:
Basics Of RDBMS, Constraints
Operators in SQL
Data Types in SQL
Statements(DDL , DML, TCL),
How to create a user and give DBA permission’s
Grouping and group by functions,
System defined functions in SQL
Sub Queries in SQL
Joins(Cartesian Join, Inner Join, Outer Join, Left outer join, Right outer join, Full outer join)
Normalization in Database
Set Operators in SQL
Index in SQL
Views in SQL

Module II : Data warehouse

What is and OLTP?
What is Data Warehouse?
OLTP Vs Data Warehouse?
Why do you need Data Warehouse?
How do you build datawarehouse
Data Staging
Definitions and descriptions
Data Warehouse Architecture
Introduction to BI tools
Introduction to ETL tools
Top Down Vs Bottom Up Approach
Data Warehouse Vs Data Marts
Type 1, Type 2 and Type 3 Slowly Changing Dimension updates
Surrogate key Concept.
Operational Data Store (ODS)
Star Schema Vs Snow Flake Schema
Facts & Dimensions
Relational Data Modeling Vs Dimensional Data Modeling?
Physical Vs Logical Modeling?

Module III: Informatica ETL tool:

I. Informatica Powercenter 9x

Explain the purpose of PowerCenter
Define terms used in PowerCenter
Name the major components of PowerCenter

2. Mapping Fundamentals

Create source and target definitions from flat files and relational tables
Create a mapping using existing source and target definitions
Use links to connect ports

3. Workflow Fundamentals

Create a basic workflow and link its tasks
Run a workflow, monitor its execution, and verify the results

4. Expression and Filter Transformations

Use expression xformations to perform calculations on a row-by-row basis
Use filter xformations to filter the record’s

5. Joining and Merging Data

Use Source Qualifier xformation to implement homogeneous joins
Use Join xformation to implement heterogeneous joins
Use Union xformation to merge records into a single record set

6. Lookup Transformation

Use lookup xformations to bring in additional data related to a row

7. Aggregator and Sorter Transformations

Order a set of records based on one or more fields using the Sorter xformation
Calculate values based on data in a set of records using the Aggregator xformation

8. Using the debugger

Use the Debug wizard and toolbar to debug a mapping

9. Updating Target Tables

Use a router xformation to divide a single set of records into multiple sets of records
Use an update strategy xformation to determine how the target should handle records

10. Mapping Techniques

Set and use variables and parameters

11. Create and use reusable transformations

Use an unconnected lookup to provide values on an as-needed basis

12. Mapplets

Create mapplets and incorporate them into mappings

13. Controlling Workflows

Set and use workflow variables
Use link conditions and decision tasks to control the execution of a workflow
Use other workflow tasks
Correctly use bulk and normal loading
Schedule workflows to run automatically

14. Repository Manager:

Creating and using a folder
Version control
Importing of Workflows
Importing of Mappings
Exporting Workflows
Exporting Mappings
Domain and Repository Connections
Creation of Users and groups
Working with folders

15. Performance Tuning:

Performance Bottleneck evaluation
Optimizing Target
Optimizing Source
Optimizing Mapping
Optimizing Transformations
Optimizing Sessions

Module IV:

    Mock Interview

Resume Preparation Tips

            1. Resume Review
            2. Resume Preparation Tips
            3. Sample Resumes

Interview Preparation

            1. Interview Preparation Tips
            2. Sample Interview Questions
            3. Tips & Guidelines for Effective Interview