Informatica Training/Informatica Training In Hyderabad

Informatica

 

Informatica Analyst Tool allows for the analysis of data by creating projects, objects, profiling data, and identifying anomalies. Learn how to use Analyst to understand relationships between tables and files, build Reference Tables and Scorecards, and manage Exceptions and Duplicate record tasks.

 

Schedules & Timings

 

 Training Modes:   Online / Classroom / Video
   
 Training Silos: Fast-Track / One-One / Weekend

 * Job Support Available

Register Today 

 

 

  Trainer Name Exp Details
  1   Mr Sri Ram 7+ Years   Profile
       
  2   Mr Bala Kishore 12+ Years   Profile
 
Informatica Training - Highlights
Register Today 

 

  Completely Real-time and Practical

  Introduction to Informatica

  Introduction to Big Data

  Hadoop Distributed File System (HDFS)

  Map/Reduce Programming – Java Programming

  Working with NOSQL

  Introduction to SPARK

 

One Real-Time Project

 



 

 

SQL DBA Training Course Content


Data Warehousing Concepts
  • Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing)
  • Slowly Changing Dimensions (SCD1, SCD2, SCD3)
  • Metadata
  • Dimentinal Table
  • Types Of Dim Tables
  • Fact Table
  • Types of Fact Tables
  • OLTP (OnLine Transaction Processing)
  • OLAP (Online Analysis And Processing)
  • OLTP Vs OLAP
  • Advantages of OLAP
  • Different Methodologies of DWH
PowerCenter Components and User Interface
  • Informatica PowerCenter Architecture
  • Informatica PowerCenter Client Tools
  • Start Using of the Designer, Workflow Manager and Workflow Monitor
Source Qualifier
  • Source Qualifier Transformation
  • SQL override in source qualifier transformation
  • Source qualifier transformation joins concept
  • Source qualifier transformation on Relational Databases
  • Source qualifier transformation on File systems
  • Source qualifier transformation filter concepts
  • Difference Between SQL Override, Other Options
  • Source Qualifier Transformation Performance Tunning
  • Pre SQL and Post in Source Qualifier Transformation
Expression, Filter, File Lists and Workflow Scheduler
  • Expression Editor
  • Filter Transformation
  • File Lists
  • Workflow Scheduler
  • Lab – Load the Customer Staging Table and Real time issues
Joins, Features and Techniques I
  • Joiner Transformation
  • Shortcuts
  • Lab A – Load Sales Transaction Staging Table
  • Lab B – Features and Techniques I and Real time issues
Lookups and Reusable Transformations
  • Lookup Transformation
  • Reusable Transformations
  • Lab A – Load Employee Staging Table
  • Lab B – Load Date Staging Table and Real time issues
Debugger
  • Debugging Mappings 
  • Lab – Using the Debugger
Sequence Generator
  • Sequence Generator Transformation 
  • Lab – Load Date Dimension Table and Real time issues 
Lookup Caching, More Features and Techniques
  • Lookup Caching
  • Lab A – Load Promotions Dimension Table
  • Lab B – Features and Techniques II
  • Review and more Lab Activities and Real time issues
Router, update Strategy and Overrides
  • Router Transformation 
  • Update Strategy Transformation 
  • Expression Default Values 
  • Source Qualifier Override 
  • Target Override 
  • Session Task Mapping Overrides 
  • Lab – Load Employee Dimension Table and Real time issues 

Module: II

Dynamic Lookup and Error Logging
  • Dynamic Lookup
  • Error Logging
  • Lab – Load Customer Dimension Table
Unconnected Lookup, Parameters and Variables
  • Unconnected Lookup Transformation 
  • System Variables 
  • Mapping Parameters and Variables 
  • Lab – Load Sales Fact Table 
Sorter, Aggregator and Self-Join
  • Sorter Transformation
  • Aggregator Transformation
  • Active and Passive Transformations
  • Data Concatenation
  • Self-Join
  • Lab – Reload the Employee Staging Table and Real time issues
  • SCD type1 – Hands-On LAB 
  • SCD type2 – Hands-On LAB 
  • SCD type3 – Hands-On LAB 
Mapplets
  • Mapplets
  • Lab – Load Product Daily Aggregate Table
  • Review and more Lab Activities and Real time issues
Workflow Variables and Tasks
  • Link Conditions
  • Workflow Variables
  • Assignment Task
  • Decision Task
  • Email Task
  • Lab – Load Product Weekly Aggregate Table
More Tasks and Re-usability
  • Event Raise Task
  • Event Wait Task
  • Command Task
  • Reusable Tasks
  • Reusable Session Task
  • Reusable Session Configuration
Worklets and More Tasks
  • Worklets
  • Timer Task
  • Control Task
  • INTRODUCTION TO ORACLE SQL DATABASE
  • RELATIONAL DATABASE CONCEPTS
  • COMMUNICATING WITH AN RDBMS USING SQL
  • RETRIEVING , RESTRICTING AND SORTING DATA(DRL)
  • FUNCTIONS AND AGGREGATED FUNCTIONS
  • DISPLAYING DATA FROM MULTIPLE TABLES (JOINS)
  • SUB-QUEIRES AND SET OPERATORS
  • DATA WAREHOUSING CONCEPTS
  • WHAT IS ONLINE TRANSACTIONAL SYSTEMS (OLTP)
  • DIFFERENCE BETWEEN OLTP AND DWH.
  • DWH LIFECYCLE
  • DATA MODELING
  • DIMENSION AND FACT TABLE
  • NOWFLAKE SCHEMA, STAR SCHEMAS
  • ODS, CUBE, HIERARCHIES
  • INTRODUCTION TO INFORMATICA AND ETL TOOL INSTALLATION
  • CONFIGURING INFORMATICA REPOSITORY SERVER
  • DESIGNER & WORKFLOW COMPONENTS
  • REPOSITORY MANAGER AND SERVER ADMIN CONSOLE
  • BLOGGING AND CONTENT MARKETING
  • TRANSFORMATIONS
  • FILTERS, AGGREGATOR, JOINERS
  • NORMALIZER, ROUTER, UNION
  • MAPPING INPUTS, OUTPUTS, PARAMETERS

Register Today