Informatica Online Training by Rizwana (English/Tamil)

Description

Informatica is a data integration and quality service tool. Informatica uses the ETL (Extract, Transform and Load) architecture. Whenever we have a data system and want to do some backend operations like cleaning up the data, modifying it and so on the basis of some rules, then we can use Informatica. As a beginner, you can expect to be hired at the entry level as an Informatica ETL Developer and then work your way up to become a Senior / Lead Developer.


After 7-10 years of experience, you can advance to Informatica Admin or Informatica Architect's job role. Other skills in BI and data warehouse could also provide you with an added advantage and help you become an ETL Architect or BI / Data Architect.

Ms.Rizwana Fathima has 3 years of experience in IT industry in both development and support. She has hands-on skill using Informatica 9.6.1, PLSQL, SQL, Unix scripting. She can guide to get good knowledge on Informatica through online training.

Training Outcome
  • Course completion certificate

  • Live one to one classes

  • Better job prospects


Requirements
  • SQL knowledge
  • ETL Concepts
  • Data Warehousing concepts

Lessons

  • 36 Lessons
  • 36:00:00 Hours
  • Introduction to ETL and Informatica Tool and other necessary connections 01:00:00
  • Basic Unix commands 01:00:00
  • Joiner and Union Transformation 01:00:00
  • Rank, Sequence Generator and Sorter Transformation 01:00:00
  • Source Qualifier and Transaction Control Transformation 01:00:00
  • What is worklet and difference between Workflow and Worklets 01:00:00
  • Lookup and difference between static and dynamic lookup 01:00:00
  • Additional illustration about Update Strategy 01:00:00
  • Table to Table Mapping/ File to File Mapping 01:00:00
  • Table to File Mapping/ File to Table Mapping 01:00:00
  • Sql – DDL,DML,TCL,DCL queries and syntax 01:00:00
  • Sql – Basic DDL,DML,TCL queries with example 01:00:00
  • Basic Unix commands 01:00:00
  • What is connected, unconnected, active and passive transformations01:00:00
  • Expression and Aggregator Transformation 01:00:00
  • Router and Filter Transformation and their difference 01:00:00
  • Lookup Transformation(Static and Dynamic) 01:00:00
  • Update strategy Transformation 01:00:00
  • What is a Mapplet and difference between Mapping and Mapplet 01:00:00
  • What is worklet and difference between Workflow and Worklets 01:00:00
  • Mapping parameter and variable01:00:00
  • Initial and Incremental load illustration and Target Load Plan 01:00:00
  • SCD1 Mapping logic explanation01:00:00
  • SCD1 Mapping with example 01:00:00
  • SCD2 Mapping logic explanation 01:00:00
  • SCD2 Mapping with example 01:00:00
  • Other SCD types 01:00:00
  • Other SCD types with example 01:00:00
  • Pre and Post Sql override and update override and when these can be used 01:00:00
  • Dynamic lookup mapping with an example in detail 01:00:00
  • Lookup and difference between static and dynamic lookup 01:00:00
  • Additional illustration about SCD Types 01:00:00
  • Additional illustration about Update Strategy 01:00:00
  • Session override, session level settings and parameter path definitions 01:00:00

About instructor

Instructor
Name : Course Monkey
Reviews : 2 Reviews
Student : 1 Students
Courses : 98 Courses

Reviews

0
Based on 0 Reviews
1 Stars
2 Stars
3 Stars
4 Stars
5 Stars