click to enable zoom
Loading Maps
We didn't find any results
View Roadmap Satellite Hybrid Terrain My Location Fullscreen Prev Next
Advanced Search

₹ 0 to ₹ 100,000

We found 0 results. Do you want to load the results now ?
Advanced Search

₹ 0 to ₹ 100,000

we found 0 results
Your search results

Informatica Course at IT Tech Rider





 
#703, 30th Main, 1st Phase, 2nd Stage,
add to favorites
680

About The Course:-

This course will cover concept such as DWH Concepts, BI,ETL,Powermart etc.,.

Who Should Take this?

Programmers, linux administrators, DBA’s, Infrastructure engineers, Data Architects, DB Administrators and  IT managers.

Pre-requisites for this training
This course requires prior knowledge of sql,pl/sql,oracle and unix.

Course Objectives:-

After completion of the course you should be able to understand :

  • What is Oracle?
  • How to create Schema /User?
  • Conditional Selection Operators
  • Difference between DELETE, TRUNCATE and DROP
  • Stored Procedure
  • DWH Concepts
  • ETL Tools
  • Informatica
  • Power Center
  • Repository
  • Hbase Introduction
  • Backend Execution
  • Data Modeling
  • Dimension Table

 1- DATA WAREHOUSING AND CLEANSING CONCEPTS

Data Warehousing/Cleansing/Merging Concepts

  • Data Cleansing
  • Data Scrubbing
  • Data Aggregation
  • Informatica power centre ETL

 2- INFORMATICA CONFIGURATION

  • Informatica Configuration
  • Integration Services
  • ETL Folder
  • ETL Job File

 3- ACTIVE AND PASSIVE TRANSFORMATION

  • Active and Passive Transformation

 4 – PRACTICAL ON EXPRESSION TRANSFORMATION

  • Expression Transformation

 5 – SHORTER/ SEQUENCE / FILTER TRANSFORMATION

  • Shorter Transformation
  • Sequence Transformation
  • Filter Transformation

 6 – JOINER TRANSFORMATION

  • Joiner Transformation

 7 – RANKING AND UNION TRANSFORMATION

  • Union Transformation
  • Ranking Transformation
  • Practical on Union Transformation

 8 – RANKING TRANSFORMATION

  • Ranking Transformation, Practical, Syntax for rank and dense rank.

 9 – ROUTER TRANSFORMATION

  • Router Transformation

 10 – SOURCE QUALIFIER TRANSFORMATION

  • Source Qualifier Transformation
  • Mapping

 11 – LOOKUP TRANSFORMATION

  • Lookup Transformation
  • Connected lookup transformation
  • Unconnected lookup transformation
  • Dynamic and Static lookup

 12 –  Slowly changing dimension

  • What is SCD?
  • Processing in XML
  • Learn how to handle Flat file
  • List and Define various Transformations
  • Implementing ‘for loop’ in Power center
  • Concepts of Pushdown optimization and Partitioning
  • What is Constraint based loading?
  • What is Incremental Aggregation?

 13 – SLOWLY CHANGING DIMENSIONS PRACTICAL SESSION

 14 – MAPPLET AND LOADING TO MULTIPLE DESIGNER

  • Mapplet designer
  • Worklet designer
  • Target load plan
  • Loading to multiple targets
  • Linking Property

Lecture 15 – Performance Tuning

  • Objectives of Performance Tuning
  • Defining performance tuning
  • Learning the sequence for tuning

 16 – Repository Manager

  • Managing Repository
  • Repository Manager – Client Tool
  • Functionalities of Previous Versions
  • Important Tasks in Repository Manager

 17 – Best Practices

  •  Understanding and adopting best Practices for managing repository

 18 – Admin Console

  • Creation of Users
  • Building Roles
  • Forming Groups
  • Collaboration of Users, Roles and Groups
  • Lock handling
  • Creating sessions, workflow and worklets

 19 – Workflow Informatica

  • Other tasks in Workflow Manager
  • Creating dependencies
  • Scope of Workflow Monitor
  • Performing other operations
  • Define Variable and Parameter in Informatica

 20 – Parameters & Variables

  • Parameter files and their scope
  • Parameter of Mapping
  • Worklet and Session Parameter
  • Workflow and Service Variable
  • Basic Development Errors

 21 – Error Handling Recovery Informatica

  • Session and Workflow log
  • Using Debuggers
  • Error Handling framework in Informatica
  • Failover and High Availability

 22 – High Availability Failover

  • Configurations and Mechanisms in Recovery
  • Checking health of PowerCenter Environment

 23 – Informatica Utilities:

Different Utilities of Informatica

  • INFACMD
  • PMREP
  • INFASETUP
  • Processing of Flat File

 24 – Flat File Processing (Advance Transformations)

  • Fixed Length and Delimited
  • Expression Transformations- Sequence numbers
  • Dynamic Targeting using Transaction Control

 25– Dynamic Targeting

  • Dynamic Target with use of transaction Control
  • Indirect loading

 26– Java Transformations

  • Transformations in Java

 27 – Unconnected Stored Procedure Usage

  • Practical & explaining the usage of Wizard

 28 – SCD Types

  • Use of SQL Transformation (Active and Passive)
  • Incremental Aggregation

 29 – Incremental Aggregation

  • Comparison between Incremental Aggregation and Incremental Loading

 30 – Constraint Based Loading

  • XML Processing

 31 – XML And Active Look Up

  • XML Transformations
  • Active lookup
  • Push-down Optimization

 32 – Push Down Optimization

  • Push down optimization
  • Partitioning

 33 – Cache Management

  • Understanding session cache
  • Importance of cache creation with
  • Implementing session cache
  • Calculating cache requirement
Good Course
  • Content
  • Instructor
  • Institute
4.7
User Rating 0 (0 votes)
Sending
Comments Rating 0 (0 reviews)
Start-End Dates: Contact Institute
Instructional Level: Appropriate for All
Certification
Quizzes
Live Projects
Doubt Clearing Sessions
Reading Material
EMI Option
Online Support
Post completion course access
Practice Exams
Placement assistance
Refund Policy
Post completion support

Compare courses

Leave a Reply

IT Tech Rider

Bangalore
7996916161
[email protected]

Contact Us