INFORMATICA
INFORMATICA ONLINE TRAINING
INFORMATICA ONLINE TRAINING IN INDIA, USA & UK
INFORMATICA ONLINE TRAINING IN CANADA
INFORMATICA ONLINE TRAINING IN AUSTRALIA
INFORMATICA ONLINE TRAINING
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
- PowerCenter 9 architecture
- PowerCenter 7 architecture vs PowerCenter 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 prouction issues and support
- Discuss various roles in ETL world
- Busines Analyst, System Analyst
- System Architect
- Technical Architect, ETL Lead
- Stakeholders, Busines users
- Effective ways of using Data warehouse
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 PowerCenter 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 PowerCenter 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 PowerCenter Server uses to extract, transform, and load data.,/li>
- 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 Powercenter
- 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 Powerconnect products to connect to other business sources such as SAP R/3, Siebel, etc.
- Mainframes: If u use Power Center, u can purchase additional Powerconnect 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
DEMOS VIDEOS
UPCOMING DEMOS
For updated Schedules please contact