top 10 online best training institutes in ameerpet, hyderabad, visakhapatnam, pune, chennai, bangalore, bengaluru, india
: sivasoft@sivasoft.in
: +91 92481 53330
WhatsApp : +91 63029 64834
top 10 online best informatica training institutes in ameerpet, hyderabad, vijayawada, visakhapatnam, pune, chennai, bangalore, bengaluru, delhi, india

ONLINE INFORMATICA TRAINING COURSE

Apply For Course
DURATION : 45 DAYS
FACULTY : Mr. IRFAN(7+Years exp)
  • Datawarehousing Concepts
    • What is DWH?
    • Characteristics of Datawarehouse
    • Difference between OLTP and DWH
    • Architecture of DWH
    • Various BI tools
    • Types of DWH
    • Types of Dimensional Data Modeling
    • Surrogate key
    • Types of Dimension
    • Data Mart
    • Star Schema
    • Snowflake Schema
    • Slowly Changing Dimension(Type 1,2 and3)
    • Confirmed Dimension
    • Summary / Aggregations table
  • Types of Transformations
    • Source Qualifier Transformation
    • Creating Simple Pass through Mapping
    • Apply Various Filter Conditions
    • Specify sorted ports
    • Eliminate Duplicate Values
    • Creating Custom SQL Query
    • Joining two or more tables
  • Filter Transformation
    • Compare with Source Filter
    • Types of Tracing Level
    • Types of Flatfiles
    • File Import Wizard
    • Load data from Flat File to Database
    • Load data from XML to Database
    • Load data from Database to Flat File
  • Sorter Transformation
    • Types of Ports
    • Multiple Sorting
    • Null Treated Low option
  • Joiner Transformation
    • Joining two heterogenouse sources
    • Types of Joins
    • Sorted input option
  • Rank Transformation
    • Types of Ports
    • Rank Index
    • Rank and Dense rank
  • Sequence Generator
    • cycle option
    • Usage of Reset
  • Expression Transformation
    • Use of Expression
    • Usage of Variable Port
    • IIF and Decode functions
  • Power Center Transformation Language
    • Conversion Functions
    • Cleansing Functions
  • Aggregator Transformation
    • Informatica aggregate functions
  • Router Transformation
    • Types of Groups
    • Group Conditions
  • Union Transformation
    • Types of Groups
  • Normalizer Transformation
    • Types of Normalizer
    • Transpose Columns to Rows
    • Default Output Ports
  • Lookup Transformation
    • Connected Vs Unconnected Lookups
    • Unconnected Procedure
  • Stored Procedure Transformation
    • Create a Sample Procedure
    • DBA Script
  • Update Strategy Transformation
    • Database opertations
    • Data Driven
  • Transaction control Transformation
    • Dynamic File Generation
    • SQL Transformation

ADVANCED INFORMATICA CONCEPTS

  • Slowly Growing Dimension
    • Slowly changing Dimension
    • Type 1
    • Type 2
    • Type 3
  • Transformation Developer
    • Create a Reusable Transformation
    • Promoting Transformations
  • Mapplet Designer
    • Create a reusable Mappings
  • Mapping Parameters
    • Design Parameter File
  • Mapping Variables
    • Set variables function
  • Session variables
    • Setting Connections
  • File Repository Concepts
    • Indirect loading
  • Target Load Plan
    • If we have multiple target which target to be loaded first.
  • Types of Load
    • Normal load
    • Bulk Load
  • Types of scheduling
    • Time-based schedule
    • Event -based schedule
  • Mapping Migration Process
    • Copy from Folder
    • Import and Export
  • Debugging Mappings
    • How to debug and find errors in mapping
  • Task Types
    • Session
    • Command
    • EMAIL
    • Timer
    • Event Wait
    • Event Raise
    • Worklet

COURSE ENQUIRY

Apply For Course


Follow us on Twitter


Like us on Facebook

Sidebar Menu