Follow Us:

Informatica Training in Chennai


Course Duration

40 HOURS
Sign in with Facebook Sign in with Facebook

About Informatica

Informatica Corporation is a software development company. Founded in 1993, it’s headquartered in Redwood City, California. It was founded by Diaz Nesamoney and Gaurav Dhillon. Sohaib Abbasi is the company’s Chairman and CEO. Informatica’s product is a portfolio focused on Data Integration: ETL, Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Master Data Management, Ultra Messaging; currently at version 9.6. These components form a toolset for establishing and maintaining enterprise-wide data warehouses. It has a customer base of over 5,000 companies.

Course Contents

Informatica
    Introduction to Data warehousing
  • Overview of a OLTP/Transactional system
  • Forms of Normalization
  • Pros/Cons of having an OLTP system in real time reporting.
  • Need of a data warehouse.
  • Data warehouse layer architecture.
  • Designing a warehouse using Star/Snowflake schemas.
  • Logical/Physical Models in Erwin  
  • Introduction to Informatica/ETL tools
  • The role of ETL tools in data warehousing
  • An introduction to Informatica
  • Informatica Architecture
  • Components/Process flow
  • Informatica Designer
  • Basic Concepts
  • Using the designer.
  • Working with the Sources-Source Analyzer
  • Working with Relational/Flat file targets- Warehouse Designer.
  • Defining Keys in Informatica.
  • Working with Transformations –Transformation Developer
  • Working with Mapplets- Mapplet designer.
  • Creating mappings –Mapping Designer.
  • Understanding Pipelines in mappings.
  • Setting Target Load order.
  • Configuring Constraint Based loading.
  • Introduction to Mapping Parameters/Variables.
  • Implementing Type1, Type2, and Type3 Mappings.
  • Loading Fact tables.
  • Working with Transformations
  • Active/Passive Transformations
  • Caching concepts in Informatica.
  • Connected/Unconnected Transformation
  • Importance of Source Qualifier.
  • Filter, Router
  • Expression
  • Sorter, Aggregator
  • Rank
  • Joiner
  • Lookup
  • Stored Procedure
  • Sequence generator
  • Union
  • Transaction Control
  • Update Strategy
  • Xml transformation
  • Normalizer
  • Creating Workflows
  • Understanding the server Architecture
  • Working with Workflows
  • Working with Tasks Assignment,Command,Decision,Control,Event raise,
  • Event Wait,Timer,Email,Session Task
  • Working with Work lets
  • Working with Sessions
  • Understanding Commit Points
  • Recovering Data
  • Monitoring Work flows
  • Using Multiple Servers
  • Log files
  • Row Error Logging
  • Session parameters
  • Parameter files
  • Using Incremental Aggregation
  • Real-Time Implementation with Informatica
  • Performance Tuning(With Real time Examples).
  • Using Incremental Aggregation
  • Extraction modes(Pull, Push).
  • Change Data capture concepts.
  • Incremental Extraction using control tables..
  • Session parameters and variables.
  • Session and Workflow properties Reference.
  • Pipeline partitioning.
  • Using Multiple Servers, Log files, Error, Row logging
  • Session Recovery.
  • Configuring Session caches lookup, Aggregate, Sort, Joiner caches.
  • Restart able Tables.
  • Reject Capture and Reprocessing.
  • Handling Soft\Hard Rejects.
  • Loading issues with respect to sources, targets, mappings, sessions, networks
Register Now

You will Learn How To :


Course Benefits :

Register Now

Please use the form below to make your career excellent.