INFORMATICA Course Curriculum

  • What is Business Intelligence (BI)?
  • Evolution of BI
  • Characteristics of an OLTP system
  • Why OLTP is not suitable for complex analysis?
  • Characteristics of a Data Warehouse
  • Define DWH and its properties
  • Subject Oriented, Integrated, Time variant, Non-Volatile
  • Define Grain/Granularity
  • Differentiate between OLTP and Data Warehouse
  • User expectations and User community
  • Enterprise Data Warehouse
  • Data Warehouse versus Data marts
  • Dependent Data marts
  • Independent Data marts
  • Data Warehouse components
  • Source systems, Staging area, Presentation area, Access tools
  • Goals of a Data Warehouse
  • Data Warehouse development approaches -
  • Top-down, Bottom-up, Hybrid, Federated
  • Incremental approach to warehouse development
  • Dimensional Modeling
  • Star Schema Fact and Dimension tables
  • Dimensions and Measure objects
  • Snowflake Schema
  • Types of Fact tables
  • Factless Fact table
  • OLAP storage modes MOLAP, ROLAP, HOLAP, DOLAP
  • Slowly and Rapidly changing Dimensions- Type I, II, III
01 Introduction to Informatica
  • Introduction to Course
  • Where InformaticaPowerCenter IPC is used
  • Data Warehouse projects and Why use Informatica
  • Roles and Responsibilities of Informatica Developer
  • Roles and Responsibilities of Informatica Administrator
  • What is InformaticaPowerCenter IPC
02 ETL and Various ETL Tools
  • What is ETL
  • Various ETL Tools in Market
03 Data Transformation
  • What is  Data Transformation
  • Types of Data Transformation
  • Example of Data Transformation
04 InformaticaPowerCenter Components
  • Informatica Power Center Components
  • PowerCenter Designer
    • Using the Designer
      • Designer Tools
      • Designer Windows
      • Working with Sources
      • Working with Flat Files
      • Working with Targets
      • Data Transformation Source and Target
      • Mappings
      • Mapplets
      • Mapping Parameters and Variables
    • Workflow Manager
    • Workflow Monitor
    • Repository Manager
    • Admin Console
05 InformaticaPowerCenter Architecture
  • Informatica Client-Server Architecture
  • Repository Services
  • Integration Service
  • What is domain
06 Installation and Configuration of InformaticaPowerCenter
  • Installation Steps Overview
  • Oracle 11g Setup and Configuration
  • PowerCenter Server Setup and Configuration
  • PowerCenter Client Setup and Configuration
07 Understanding Source and Target
  • Types of Sources
  • Type of targets
  • Source Analyzer in Informatica
  • Target Designer in Informatica
08 Create Mappings, Session and Workflows
  • Create a Mapping To load Source Table to Target Table
  • Create a Mapping to load Source Table to Flat file Target
  • Create a Mapping to load Flat File Source to Target Table
  • Creating a Session and Workflow
09 Session Properties
  • Session properties Overview
  • Fail Parent if Task Fails
  • Write Backward Compatibility Session Log File
  • Bulk vs Normal Load
  • Save Session Log for These Runs
  • How to use Pre or Post SQL
  • How to Send Email
  • Stop on Error
  • Commit Interval
10 Link Conditions
  • Link Conditions Concept
  • Link Condition Example
11 Multiple Target and Target Load Plan
  • Loading Source data to multiple target - File and Relational
  • Target Load Plan Concept
  • Target Load Plan Example
  • Issues with having 2 pipeline loads in 1 mapping
12 Transformations
  • Active and Passive Transformations
13 Expression Transformation
  • Expression Transformation Concepts
  • Expression Transformation Example
  • IIF Expression Example
  • ERROR Function in Expression
  • ABORT Function in Expression
  • Difference between ERROR and ABORT
14 Filter Transformation
  • Filter Transformation Concept
  • Filter Transformation Example
  • Filter Transformation to Monitor Performance Concept
  • Filter Transformation to Monitor Performance Example
15 Router Transformation
  • Router Transformation Concept
  • Router Transformation Example
16 Joiner Transformation
  • Join Concept
  • Joiner Transformation Inner or Equi Join Example
  • Joiner Transformation Right Outer Join Example
  • Joiner Transformation Left Outer Join Example
  • Joiner Transformation Full Outer Join Example
17 Lookup Transformation
  • Lookup Transformation Concept
  • Simple Lookup Table example
  • Lookup Transformation Multiple Match Values Concept
  • Lookup Transformation First Value Example
  • Lookup Transformation Last Value Example
  • Lookup Transformation Any Value Example
  • Lookup Transformation Report Error Example
  • Lookup Transformation UseAll Values Example
  • Unconnected and Connected Lookup Concept
  • 0Unonnected Lookup Example
18 How to use Informatica Help
  • How to use Informatica Help for more functions
19 Union Transformation
  • Union Transformation Concept
  • Union Transformation Example
20 Sorter Transformation
  • Sorter Transformation Concept
  • Sorter Transformation Example with 1 key
  • Sorter Transformation Example with more than 1 key
  • Sorter Transformation to get unique records after Union
21 Aggregator Transformation
  • Aggregator Transformation concepts
  • Aggregator Transformation Example
  • Use of Aggregator to remove duplicates Concept
  • Use of Aggregator to remove duplicates Example
22 Update Strategy Transformation
  • Update Strategy Transformation Part 1
  • Update Strategy Transformation Part 2
23 Rank Transformation
  • Rank Transformation Concept
  • Rank Transformation Example - Using TopBottom Ranking
24 Sequence Generator Transformation
  • Sequence Generator Transformation Concept
  • Sequence Generator Transformation Example
25 Stored Procedure Transformation
  • Stored Procedure Transformation Concept
  • Stored Procedure Transformation Example
26 Slowly Changing Dimension
  • Slowly Changing Dimension Concept
  • SCD Type1 Concept
  • SCD Type1 Example
  • SCD Type2 Concept
  • SCD Type2 Example
  • SCD Type3 Concept
  • SCD Type3 Example
27 Workflow
  • What is Workflow
  • Creating Workflow
  • Monitoring workflows and debugging errors
28 Tasks
  • What is Task
  • Creating Decision task
  • Creating Control Task
  • Creating Event wait task
  • Creating Timer task
  • What is Reusable tasks - session, email and command
  • Creating Reusable tasks
29 Reusability - WorkletMaplet
  • What is Worklet
  • Creating Worklet
  • What is Maplet
  • Creating Maplet
  • Reusable Transformations Concept
  • Reusable Transformations Example
30 Sessions
  • What is Session
  • Creating Session
31 Scheduling Workflow
  • What is Scheduler
  • Using Scheduler to run example
32 Import - Export of Objects
  • Export Example
  • Import Example
  • Folder Copy
33 Indirect File Load
  • Indirect File Load Concept  Examples
34 Integrity Constraint Load Ordering
  • Integrity Constraint concept
  • primary key and foreign key example
  • Constraint based loading example
35 Session Parameters and Variables
  • Session Parameters Concept
  • Session Parameters Example
36 Target Load Order Plan
  • Traget Load plan Concept
  • Where or When we need Target Load Plan
  • Traget Load plan Example
37 Informatica Interview Questions

Testimonials

Had very much interest to learn SAP MM training course, so I joined in this centre and paid fees of Rs.12,000 for 45 days duration. Their response was good and I'm highly satisfied with their coaching.

Mr. Deepak

I joined this institute for SAP FICO Training. The trainers are friendly and are clearing all our doubts. I paid Rs11000 for this 3 months course fees. I'm gratified with their service.

Shaikh Imran

In this institution only I had joined HADOOP course, I paid fees of Rs.12,000 for one month duration and they provided study materials also. I preferred daily morning batches and I'm satisfied with their coaching.

Shilpa

I am glad with this institution who offered me fine classes for SAP CRM with the reasonable fees of Rs15000, the duration of class is 2 months, Thanks for the tutors who provided me valuable classes.

Anil Kolla

It's an excellent training with real time experience faculty by mr.shiva sir having 11years of experience. Hadoop is up coming big data related tool database maintenance. i think this gona work out for every developer.....PRIMARK INFOTECH providing this big data concept "hadoop" with good training classes.

Vardhan

I was looking for training institute to get trained in SAP BO and had joined in this institute. Their coaching and training is good and the fee is nominal, even the class timings are convenient.

Suseela
  • SAP BODS

    Duration : 45 days (With Real Time Project)
    Faculty : MR.Shankar 10+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP HANA(Development & Admin)

    Duration : Regular Batch(45 Days), (4-5 weeks) Weekend Batches With Realtime Examples,(With Real Time Projects)
    Faculty : Mr.Shankar (Real Time Experienced Consultant).
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 24/7 up to 45 Days
    Weekends : Sat & Sun: 10 to 2
  • SAP FI/CO

    Duration : 3 Months(With Real Time Projects)
    Faculty : MR. Raj Kumar, 7+ Yrs real time Experienced Consultant.
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2Months
  • SAP BPC

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mr. Srini,14+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2Months
  • SAP S4 HANA Simple Finance

    Duration : 30 days (With Real Time Projects)
    Faculty : Mr. Srini,14+ Yrs real time Experienced Consultant.
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 45days
  • SAP ABAP

    Duration : 3 Months (With Real Time Projects)
    Faculty : Mr.Sridhar 8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP MM

    Duration : 45 days (With Real Time Projects)
    Faculty : Mr. Prakash,10+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP SD

    Duration : 45 days (With Real Time Projects)
    Faculty : Mr. Jayram, 8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP HR-HCM

    Duration : 2Months (With Real Time Projects)
    Faculty : Mrs.Rohini 8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP Success Factors

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mrs.Rohini 8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP PP /QM

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mr. Ramesh,8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP HYBRIS(Functional & Technical)

    Duration : 40 Days (With Real Time Projects)
    Faculty : Mr. Kiran,10+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP BASIS

    Duration : 30 Days (With Real Time Projects)
    Faculty : Mr. Avinash,5+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP EHS

    Duration : 30 Days (With Real Time Projects)
    Faculty : Mr. Prasad,14+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • Digital Marketing

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mr.Yedukondalu, 8+ Yrs Realtime Experience.
    Material : Free
    Lab : 7AM TO 8PM
  • Data Science

    Duration : 60 Days (With Real Time Projects)
    Faculty : Mr.Aditya,8+ Yrs Realtime Experience.
    Material : Free
    Lab : 7AM TO 8PM
  • Hyperion(ESS Base,Oracle Planning & HFM)

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mr.Kumar, 4+ Yrs Realtime Experience.
    Material : Free
    Lab : 7AM TO 8PM