INFORMATICA TRAINING

INFORMATICA TRAINING
AcuteSoft is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies.AcuteSoft has a pool of Expert Trainers worldwide on all the technologies to train the students.AcuteSoft is offering Training services to Major IT giants and to individual students worldwide.About Our faculty: we have excellent Informatica instructors who have real time experience plus expert orientation in Informatica Training.
INFORMATICA TRAINING
We offer you:
1. Interactive Learning at Learners convenience
2. Industry Savvy Trainers
3. Learn Right from Your Place
4. Customized Curriculum
5. 24/7 system access
6. Highly Affordable Courses
7. Support after Training
a. Resume Preparation
b. Certification Guidance
c. Interview assistance
We have a forth coming online batch on Informatica Training .
We also provide online training on SAP FICO, SAP SD, SAP WM, SAP PP, SAP MM, SAP SRM, SAP FSCM , SAP MDM, SAP APO, SAP IS RETAIL, SAP CRM, SAP ABAP, SAP BI, SAP BASIS, SAP BO, SAP HANA, SAP BPC , SAP ESS-MSS , SAP CS, SAP PLM , SAP GTS, SAP SNC , Informatica , Cognos ,OBIEE, SAS, Oracle Apps All Modules, Testing Tools, Android, iPhone, Hyperion and Big Dada hadoop.

Experience the Quality of our Online Training. For Free Demo Please Contact
AcuteSoft :
India: +91-9848346149, +91-7702226149
Land line:  +91 (0)40 - 42627705
US: +1 973-619-0109, +1 312-235-6527
UK : +44 207-993-2319
Skype id : acutesoft
Email id: info@acutesoft.com
http://www.acutesoft.com            
http://training.acutesoft.com

INFORMATICA TRAINING

INFORMATICA TRAINING
AcuteSoft is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies.AcuteSoft has a pool of Expert Trainers worldwide on all the technologies to train the students.AcuteSoft is offering Training services to Major IT giants and to individual students worldwide.About Our faculty: we have excellent Informatica instructors who have real time experience plus expert orientation in Informatica Training.
INFORMATICA TRAINING
We offer you:
1. Interactive Learning at Learners convenience
2. Industry Savvy Trainers
3. Learn Right from Your Place
4. Customized Curriculum
5. 24/7 system access
6. Highly Affordable Courses
7. Support after Training
a. Resume Preparation
b. Certification Guidance
c. Interview assistance
We have a forth coming online batch on Informatica Training .
We also provide online training on SAP FICO, SAP SD, SAP WM, SAP PP, SAP MM, SAP SRM, SAP FSCM , SAP MDM, SAP APO, SAP IS RETAIL, SAP CRM, SAP ABAP, SAP BI, SAP BASIS, SAP BO, SAP HANA, SAP BPC , SAP ESS-MSS , SAP CS, SAP PLM , SAP GTS, SAP SNC , Informatica , Cognos ,OBIEE, SAS, Oracle Apps All Modules, Testing Tools, Android, iPhone, Hyperion and Big Dada hadoop.

Experience the Quality of our Online Training. For Free Demo Please Contact
AcuteSoft :
India: +91-9848346149, +91-7702226149
Land line:  +91 (0)40 - 42627705
US: +1 973-619-0109, +1 312-235-6527
UK : +44 207-993-2319
Skype id : acutesoft
Email id: info@acutesoft.com
http://www.acutesoft.com            
http://training.acutesoft.com

Informatica Online Training

  INFORMATICA

Informatica is one of the most popular ETL (Extraction, Transformation and Loading) tools in the market today. Informatica Power Center provides an environment to load data into a centralized location such as an Operational data Store (ODS) or a data mart or a data warehouse. U can extract the data from various data sources such as flat files, or any Database or even COBOL files, Transform the data based in business logic and load data into different types of targets including files and relational databases.

      Informatica provides the following components:

• Informatica Repository

• Informatica Client

• Informatica Server

 Informatica Repository:

 The Repository is the core of the Informatica suite. Repository database contains a set of metadata tables that the Informatica tools and applications access. The Informatica Client and server access the repository to save and retrieve metadata. Informatica Client: The Power Center Client is comprised of applications that you use to manage the repository, design mappings and mapplets, create sessions and workflows to load the data, and monitor workflow progress.The Informatica Client consists of three client applications.

• Repository Manager

• Designer

• Server Manager

     In this tutorial, you use the following applications and tools:

   Repository Manager :

Use the Repository Manager to create and administer the metadata repository. You use the Repository Manager to create a repository user and group. You create a folder to store the metadata you create in the lessons. Repository Server Administration Console. Use the Repository Server Administration console to administer the Repository Servers and repositories. Designer Use the Designer to create mappings that contain transformation instructions for the Power Center Server. Before you can create mappings, you must add source and target definitions to the repository. Designer comprises the following tools:

• Source Analyzer. Import or create source definitions.

• Warehouse Designer. Import or create target definitions.

• Mapping Designer. Create mappings that the Power Center Server uses to extract, transform, and load data.

• Workflow Manager. Use the Workflow Manager to create and run workflows and tasks. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data.

• Workflow Monitor. Use the Workflow Monitor to monitor scheduled and running workflows for each PowerCenter Server.

  Informatica Server: 

The Informatica Server extracts the source data, performs the data transformation and loads the transformed data into the targets. Sources accessed by Power center

• Relational: Sybase, Oracle, IBM DB2, Informix, MS SQL Server and Teradata.

• File: Fixed and delimited flat files, COBOL files and XML files

• Extended: If u use Power Center, u can purchase additional Power connect products to connect to other business sources such as SAP R/3, Siebel, etc.

• Mainframes: If u use Power Center, u can purchase additional Power connect products to connect to IBM DB2 on MVS

• Others: MS Access and MS Excel

    Informatica repository

The Informatica repository is at the center of the Informatica suite. You create a set of metadata tables within the repository database that the Informatica applications and tools access. The Informatica Client and Server access the repository to save and retrieve metadata.

    Informatica Client

Use the Informatica Client to manage users, define sources and targets, build mappings and mapplets with the transformation logic, and create sessions to run the mapping logic. The Informatica Client has three client applications: Repository Manager, Designer, and Workflow Manager.

    Informatica Server

The Informatica Server extracts the source data, performs the data transformation, and loads the transformed data into the targets.

    Process Flow

• Informatica Server moves the data from source to target based on the workflow and metadata stored in the repository.

• A workflow is a set of instructions how and when to run the task related to ETL.

• Informatica server runs workflow according to the conditional links connecting tasks.

• Session is type of workflow task which describes how to move the data between source and target using a mapping.

• Mapping is a set of source and target definitions linked by transformation objects that define the rules for data transformation.

    Transformations

• A transformation is a repository object that generates, modifies, or passes data

• The Designer provides a set of transformations that perform specific functions

• Data passes into and out of transformations through ports that you connect in a mapping or mapplet

• Transformations can be active or passive

Informatica Course Content

Informatica Course Curriculum
   
   Data Warehouse Concepts

• Introduction to Data warehouse

• What is Data warehouse and why we need Data warehouse

• OLTP vs ODS vs Data warehouse

• Dimensional modeling

• Star schema/Snowflake schema/Galaxy schema

• Dimensions / Facts tables

• Slowly Changing Dimensions and its types

• Data Staging Area

• Different types of Dimensions and Facts

• Data Mart vs Data warehouse

• DWH Approaches: Ralph Kimball's vs Bill Inmon's

   Informatica Power Center

• Software Installation

• Informatica 9 Server/Client Installation on Windows

   Power Center Architecture and Components

• Introduction to informatica Power Center

• Difference Between Power Center and Power Mart

• Power Center 9 architecture

• Power Center 7 architecture vs Power Center 8 and 9 architecture

• Extraction, Transformation and loading process

• Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager, Informatica Adminstration Console.

• Repository Server

• Repository maintenance

• Repository Server Administration Console

• Security, Repository, privileges and folder permissions

• Metadata extensions

   Power Center Developer Topics

• Create a Folder

• How to provide Previllages

• Source Object Definitions

    Source types

• Relational Tables (Oracle, Teradata)

• Flat Files (fixe width, Delimiter Files)

• Xml Files

    Source properties
   

    Analyze Source Data, Import Source
   

    Target Object Definitions

• Target types

• Target properties

    Import Targets

• Transformation Concepts

• Transformation types and views

• Transformation features and ports

• Informatica functions and data types

     Mappings

• Mapping components

• Source Qualifier transformation

• Pre SQL and Post SQL

• Mapping validation

• Data flow rules

     Create a Mapping, session, and workflow

• Workflows

• Workflow Tools

• Workflow Structure and configuration

• Workflow Tasks

• Workflow Design and properties

     Session Tasks

• Session Task properties

• Session components

• Transformation overrides

• Session partitions

    Workflow Monitoring

• Workflow Monitor views

• Monitoring a Server

• Actions initiated from the workflow Monitor

• Gantt chart View and Task view.

    Start and Monitor a Workflow

• Debugger

• Debugger features

• Debugger windows

• Tips for using the Debugger

     The Debugger

• Expression transformation

• Expression, variable ports, storing previous record values.

• Different type of Ports

• Input/ output / Variable ports and Port Evaluation

• Filter transformation

• Filter properties

    Expression and Filter

• Aggregator transformation

• Aggregation function and expressions

• Aggregator properties

• Using sorted data

• Incremental Aggregation

     Joiner transformation

• Joiner types

• Joiner conditions and properties

• Joiner usage and Nested joins

     Aggregator, Heterogeneous join
 

     Working with Flat files
     

     Importing and editing flat file sources & Targets
 

     Lab Session Use Flat file as source. Sorter transformation
 

     Sorter properties

• Sorter limitations

    Sorter

• Propagate Attributes.

• Shared Folder and Working with shortcuts.

• Informatica built in functions.

    Lookup transformation

• Lookup principles

• Lookup properties

• Lookup techniques

• Connected and unconnected lookups, Lookup Caches

     Basic and Advance Lookup Target options

• Row type indicators

• Row loading operations

• Constraint- based loading

• Rejected row handling options

    Deleting Rows

• Update Strategy transformation

• Update strategy expressions

• Data Driven Inserts and Rejects

• Router transformation

• Using a router

• Router groups

     Router Conditional Lookups

• Usage and techniques

• Advantage

• Functionality

     Straight Load
 

    Conditional Lookups

• Heterogeneous Targets

• Heterogeneous target types

• Target type conversions and limitations

     Heterogeneous Targets Mapplets

• Functionality and Advantages

• Mapplet types and structure

• Mapplet limitations

     Mapplets

• Reusable transformations

• Advantages

• Limitations

• Promoting and copying transformations

     Reusable transformations /Sequence Generator transformation

• Using a sequence Generator

• Sequence Generator properties

• Dynamic Lookup

• Dynamic lookup theory

• Usage and functionality

• Advantages

     Dynamic Lookup Concurrent and sequential Workflows

• Concurrent Workflows

• Sequential Workflows

• Stopping, Starting and suspending tasks and workflows

     Sequential Workflow Additional Transformations

• Union Transformation

• Rank transformation

• Normalizer transformation

• Custom Transformation

• Transformation Control transformation

• XML Transformation

• SQL Transformation

• Stored Procedure Transformation

• External procedure Transformation

• SQL Transformation

     Lab Sessions- For above transformations Error Handling

• Overview of Error Handling Topics

• Review various BI Reporting methods

• Informatica - Best practices

• Mapping Design through Visio tool

• Data Loading techniques for huge volume of data

• XML Data Loading Best Practices

• Incremental Loading and Rollback procedures

• Slowly changing dimension Overview

• Caching VS Direct load

• Transaction Handling

• Performance Tuning

• Traceability and Event Logging

     Error handling fatal and non Fatal Workflow Tasks

• Command

• Email

• Decision

• Timer

• Control

• Even Raise and Wait

• Sequential Batch Processing

• Parallel Batch Processing

      Lab Sessions With Workflow tasks Link Conditions Team Based Development

• Version Control

• Checking out and checking in objects

• Performance Tuning

• Overview of System Environment Identifying Bottlenecks

• Optimizing Source, Target, mapping, Transformation, session

• Mapping Parameters and Variables

     Introduction to Mappng Variables and Parameters
 

     Creating Mapping Variables and Updating Variables
      

     Creating Parameter File and associating file to a Session
    

      System Variables
 

      Variables functions
 

      Override Mapping Variable with Parameter Files
     

      Dynamically Updating a Source Qualifier with Mapping Variable

• Slowly Changing Dimensions Type 1, Type 2, Type 3

• Incremental Loading

     SCD 1, 2, 3

• Reusable Workflow Tasks

• WorkLets

• Worklets Limitation

• Sessions

• Reusable Sessions

    Create Worklets using Tasks Command Line Interface ( PMCMD)

• Overview of PMCMD and functions

• Overview of PMREP and functions

     PMCMD

• PMREP

• Informatica Migrations:

• Copying Objects

• Objects export and import (XML)

• Deployment groups

    Workflows Scheduling

• Using Informatica

• Unix crontab, third party tools

    Informatica Project- Case Study

• Sales Data mart

• Loading Dimensions and Facts

    ETL Best Practices and methodologies

• Review the Industry best practices in ETL Development

• Review Real time project experiences of trainer

• Discuss what is learned techniques are useful in real world

• How to design effective ETL process

• Important considerations in designing ETL process

• Discuss real world production issues and support

• Discuss various roles in ETL world

• Business Analyst, System Analyst

• System Architect

• Technical Architect, ETL Lead

• Stakeholders, Business users

• Effective ways of using Data warehouse

Informatica Interview Questions

   What are the new features of Informatica 9.x in developer level ?

• From a developer's perspective, some of the new features in Informatica 9.x are as follows:

• Now Lookup can be configured as an active transformation - it can return multiple rows on successful match

• Now you can write SQL override on un-cached lookup also. Previously you could do it only on cached lookup

• You can control the size of your session log. In a real-time environment you can control the session log file size or time

• Database deadlock resilience feature - this will ensure that your session does not immediately fail if it encounters any database deadlock, it will now retry the operation again. You can configure number of retry attempts.

   What are ETL Tools ?

ETL Tools are stands for Extraction, Transformation, and Loading the data into the data warehouse for decision making. ETL refers to the methods involved in accessing and manipulating source data and loading it into target database.

   What are Dimensional table ?

Dimension tables contain attributes that describe fact records in the fact table.

   What is data Modeling ?

• Data Modeling is representing the real world set of data structures or entities and their relationship in their of data models, required for a database. Data Modeling consists of various types like :

• Conceptual data modeling

• Logical data modeling

• Physical data modeling

• Enterprise data modeling

• Relation data modeling

• Dimensional data modeling.

   What is Surrogate key ?

Surrogate key is a substitution for the natural primary key. It is just a unique identifier or number of each row that can be used for the primary key to the table.

   What is Data Mining ?

A Data Mining is the process of analyzing data from different perpectives and summarizing it into useful information.

   What is Operational Data Store ?

A ODS is an operational data store which comes as a second layer in a data warehouse architecture. It has got the characteristics of both OLTP and DSS systems.

   What is the Difference between OLTP and OLAP ?

OLTP is nothing but Online Transaction Processing which contains a normalized tables.
But OLAP(Online Analytical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System.

   How many types of dimensions are available in Informatica ?

      There are three types of dimensions available are :

• Junk dimension

• Degenerative Dimension

• Conformed Dimension

   What is Difference between ER Modeling and Dimensional Modeling ?

• ER Modeling is used for normalizing the OLTP database design.

• Dimensional modeling is used for de-normalizing the ROLAP / MOLAP design.

   What is the maplet ?

Maplet is a set of transformations that you build in the maplet designer and you can use in multiple mappings.

   What is Operational Data Store ?

A ODS is an operational data store which comes as a second layer in a data warehouse architecture. It has got the characteristics of both OLTP and DSS systems.

   What is the Difference between OLTP and OLAP ?

OLTP is nothing but Online Transaction Processing which contains a normalized tables.
But OLAP(Online Analytical Programming) contains the history of OLTP data which is non-volatile acts as a Decisions Support System.