Informatica Online Training


IQ training facility offers Informatica Online Training. Our Informatica trainers come with vast work experience and teaching skills. Our Informatica training online is regarded as the one of the Best online training in India. All our students were happy and able to find Jobs quickly in USA, UK, Singapore, Japan, Europe. Informatica training online is your one stop solution to learn Informatica at the comfort of your home with flexible schedules.

IQ Training offers the Informatica Online Course in a true global setting.

Course Objectives

Course Curriculum

1. Introduction to ETL Logic
2. Overview of Staging Area
3. Need of ETL Logic
4. Difference between OLTP systems and OLAP systems
5. Overview on Data Warehousing concepts
6. Introduction to Data Modeling
7. Overview on Database
8. Construction of DWH/Data marts using ETL logic
9. Introduction to Informatica Power Center
10. Difference between various versions of Power center
11. Overview of sub tools of the Informatica Power Center:

  • Informatica Client
  • Informatica Server
  • Informatica Repository
  • Informatica Repository server
  • Overview on integration service
  • Internal Architecture of the server

12. Informatica client:

  • Informatica designer
  • Workflow manager
  • Workflow monitor
  • Repository manager
  • Repository server administrative console

13. Working with Power center administrative console

  • Create a folder
  • Create a repository service
  • Create an integration service
  • Create users and users groups and assign privileges
  • Working with logs
  • Explanation on data movement mode
    • ASCII and Unicode

14. Informatica Designer:

  • Source analyzer
  • Ware house designer/ target designer
  • Transformation developer
  • Mapplet designer
  • Mapping designer

15. Workflow manager:

  • Workflow designer
  • Worklett designer
  • Task developer

16. Transformations:

  • Reusable transformations
  • Non-reusable transformations
  • Active and Passive transformations
    • a) Source qualifier
    • b) Expression
    • c) Aggregator
    • d) Rank
    • e) Filter
    • f) Router
    • g) Lookup
      • i) Connected
      • ii) Unconnected
      • iii) Difference between Dynamic Lookup, Static Lookup, Persistence Lookup And Re-cache from the source
    • h) Stored Procedure and function
      • i) Connected
      • ii) Unconnected
    • i) Update Strategy
    • j) Transaction control
    • k) Normalizer
    • l) Sequence generator
    • m) Union
    • n) Joiner ( Normal, Master outer, detail Outer, Full Outer)
    • o) XML Source qualifier
    • p) Sorter
    • q) Mapplet input
    • r) Mapplet Output

17. Advanced Transformations:

  • Java Transformation
  • Sql Transformation
  • HTTP transformation
  • SAP R/3 Transformation
  • Data Masking
  • Data Unstructured
  • Mapping designer:
    • a) Best practices when building mappings
    • b) Construction of complex mappings for dimension tables and fact tables
  • Dimension mappings:
    • a) SCD type-1
    • b) SCD type-2
      • i) Flag current data
      • ii) Effective data range
      • iii) Version number mapping
    • c) SCD type-3
    • d) Design type-1, type-2, and type-3 dimensions for various requirements within a single mapping (Hybrid Dimension-HSCD).
    • e) Working with rapidly changing dimensions (Monster Dimensions)
    • f) Construction of the complex mappings for Data warehousing
    • g) Creation of the cubes
      • i) Analysis of Business user requirements

18. Combined type-1,type-2 and type-3 in a single mapping
19. Working with SCD wizards
20. Working with Rapidly Changing dimensions (RCD).
21. Development of the target tables based on business user requirements
22. Source analyzer:

  • Import source tables from different data bases or flat files
  • Working with XML files
  • Working with COBOL files
  • Create new source tables in the sources analyzer
  • Define the relationships
  • Create source tables in source analyzer itself.

23. Target designer:

  • Import target tables from different data bases or flat files
  • Create target tables in target designer itself.
  • Reusable transformations in Transformation developer
    Transformation logic development in Mapplet designer
  • Properties explanation of the transformations
  • Customized query generation in source qualifier
  • Pre and post sql

24. Differences between source qualifier and joiner transformation with practical explanation
25. Difference between filter and router transformations with practical explanation
26. Difference between expression and aggregator transformation with practical explanation
27. Overview of the workflow manager

  • Reusable tasks development in task developer
  • Tasks logic development in worklett designer
  • Workflow development in workflow designer
  • Design sequential and concurrent batch workflow

28. Explanation of the different types of the memories

  • Buffer, Cache

29. Overview of the load manager
30. Overview of the Data transformation manager
31. Overview of different types of tasks:

  • Start task
  • Session task
  • Event wait
  • Event raise
  • Timer
  • Decision task
  • Control task
  • E-mail task
  • Command task
  • Mapping parameters and variables creation
  • Parameter file creation
  • Internal working function of the Informatica Power center
  • Parallel Pipeline partitioning
  • Creation and deletion of partitioning points

32. Execution of the mappings:

  • Normal execution
  • Debugging mode execution

33. Loading:

  • Normal loading
  • Bulk loading
  • Constraint based loading

34. Lookup cache:

  • Static
  • Dynamic
  • Re-cache from source
  • Persistent cache
  • Shared cache

35. Introduction to Load Manager (LM)
36. Overview on DTM (Data Transformation Manger)
37. Working with Parallel pipeline partitioning mechanism:

  • Source level, transformations level and target level.

38. Introduction Threads
39. Types of threads:

  • Reader thread
  • Transformation thread
  • Writer thread
  • Pre-session thread
  • Post-session thread

40. Analysis of BRS
41. Development of RRS

  • Sample project development:
    • a) Star Schema Design with Dimension Tables and fact table.
    • b) Benefits of Star Schema
    • c) Overview on foreign keys and candidate key
    • d) Design a complex workflow for sample project

Download Material


Write a Review