INFORMATICA ONLINE TRAINING

INFORMATICA ONLINE 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 Online Training.
INFORMATICA ONLINE TRAININGWe 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 Online 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
Santhosh /Lakshmi :
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

Welcome to Informatica Online Training..

AcuteSoft is one of the leading IT training Institutions which is located in Hyderabad with the objective of providing a Training services for various requirements in IT industry. AcuteSoft is started by a group of highly talented faculty in their respective courses. Acute Soft is a passion for our team members.We are the one among the Computer Institutes in Hyderabad,India,USA,UK where faculty has enthusiasm, professionalism and high level of technical knowledge.

Informatica Course Curriculum

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, Tera data)

• 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 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 Mapping 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

• Work Lets

• Work lets 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 prouction 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 course Online Training

About  Informatica

Informatica's product portfolio focused on Data Integration: Application Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Enterprise Data Integration, Master Data Management, Messaging; These components form a toolset for establishing and maintaining enterprise-wide data warehouses, including the key used for ETL processing.


online Trainng at Acutesoft

AcuteSoft is one of the leading IT training Institutions which is located in Hyderabad with the objective of providing a Training services for various requirements in IT industry. Acute Soft is started by a group of highly talented faculty in their respective courses. Acute Soft is a passion for our team members. We are the one among the Computer Institutes in Hyderabad,India,USA,UK Where faculty has enthusiasm, professionalism and high level of technical knowledge.

Informatica Interview Questions and Answers

   1. What is Data warehouse ?

According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”.

   2. what are the types of data warehouses ?

There are three types of data warehouses

• Enterprise Data Warehouse

• ODS (operational data store)

• Data Mart

   3. What is Data mart ?

A data mart is a subset of data warehouse that is designed for a particular line of business, such as sales, marketing, or finance. In a dependent data mart, data can be derived from an enterprise wide data warehouse. In an independent data mart can be collected directly from sources.

   4. What is star schema ?

A star schema is the simplest form of data warehouse schema that consists of one or more dimensional and fact tables.

    5. What is snow flake schema ?

A Snowflake schema is nothing but one Fact table which is connected to a number of dimension tables, The snowflake and star schema are methods of storing data which are multidimensional in nature.

    6. 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.

   7. What are Dimensional table ?

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

   8. What is data Modelling ?

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 Modelling consists of various types like :

• Conceptual data modeling
• Logical data modeling
• Physical data modeling
• Enterprise data modeling
• Relation data modeling
• Dimensional data modeling.

    9. 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.

   10. What is Data Mining ?

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

   11. 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.

   12. What is the Difference between OLTP and OLAP ?

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

   13. How many types of dimensions are available in Informatica ?

There are three types of dimensions available are :

• Junk dimension
• Degenerative Dimension
• Conformed Dimension

   14. What is Difference between ER Modeling and Dimensional Modeling ?

• ER Modeling is used for normalizing the OLTP database design.
• Dimesional modeling is used for de-normalizing the ROLAP / MOLAP design.

   15. What is the maplet ?

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

  16. What is Session and Batches ?

• Session: A session is a set of commands that describes the server to move data to the target.

• Batch: A Batch is set of tasks that may include one or more numbar of tasks (sessions, email, command, etc).

   17.What are slowly changing dimensions ?

Dimensions that change overtime are called Slowly Changing Dimensions(SCD).

• Slowly Changing Dimension-Type1 : Which has only current records.
• Slowly Changing Dimension-Type2 : Which has current records + historical records.
• Slowly Changing Dimension-Type3 : Which has current records + one previous records.

   18. What are 2 modes of data movement in Informatica Server ?

There are two modes of data movement are:

• Normal Mode in which for every record a separate DML stmt will be prepared and executed.

• Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

  19. What is the difference between Active and Passive transformation ?

• Active Transformation:An active transformation can change the number of rows that pass through it from source to target i.e it eliminates rows that do not meet the condition in transformation.

• Passive Transformation:A passive transformation does not change the number of rows that pass through it i.e it passes all rows through the transformation.

  20. What is the difference between connected and unconnected transformation ?

• Connected Transformation:Connected transformation is connected to other transformations or directly to target table in the mapping.

• Unconnected Transformation:An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.

  21. What are different types of transformations available in Informatica ?

There are various types of transformations available in Informatica :

• Aggregator
• Application Source Qualifier
• Custom
• Expression
• External Procedure
• Filter
• Input
• Joiner
• Lookup
• Normalizer
• Output
• Rank
• Router
• Sequence Generator
• Sorter
• Source Qualifier
• Stored Procedure
• Transaction Control
• Union
• Update Strategy
• XML Generator
• XML Parser
• XML Source Qualifier

   22. What are Aggregator Transformation ?

Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages and sums (mainly to perform calculations on multiple rows or groups).

   23. What are Expression transformation ?

Expression transformation is a Passive and Connected transformation. This can be used to calculate values in a single row before writing to the target.

  24. What are Filter transformation ?

Filter transformation is an Active and Connected transformation. This can be used to filter rows in a mapping that do not meet the condition.

   25. What are Joiner transformation ?

Joiner Transformation is an Active and Connected transformation. This can be used to join two sources coming from two different locations or from same location.

   26. Why we use lookup transformations ?

Lookup Transformations can access data from relational tables that are not sources in mapping.

   27. What are Normalizer transformation ?

Normalizer Transformation is an Active and Connected transformation. It is used mainly with COBOL sources where most of the time data is stored in denormalized format. Also, Normalizer transformation can be used to create multiple rows from a single row of data.

   28. What are Rank transformation ?

Rank transformation is an Active and Connected transformation. It is used to select the top or bottom rank of data.

   29. What are Router transformation ?

Router transformations an Active and Connected transformation. It is similar to filter transformation. The only difference is, filter transformation drops the data that do not meet the condition whereas router has an option to capture the data that do not meet the condition. It is useful to test multiple conditions.

   30. What are Sorter transformation ?

Sorter transformation is a Connected and an Active transformation. It allows to sort data either in ascending or descending order according to a specified field.