Welcome To Eazygurus

Informatica

Course Name         :   DATA WAREHOUSING – INFORMATICA Training
Duration                 :  35 hrs

0 STUDENTS ENROLLED

    • Introduction to Data warehousing
      • What is Data warehousing?
      • Who needs Data warehouse?
      • Why Data warehouse is required?
      • Types of Systems
        • OLTP
        • DSS
      • Maintenance of Data warehouse
      • Data warehousing Life Cycle
      • Data warehousing Testing Life Cycle
        • Cold Backup
        • Hot Backup
    • Data warehousing Architecture
      • Source
      • Integration Layer
      • Staging Area
      • Targets
      • Analysis & Reporting
      • ODS
    • Data Modeling
      • Introduction
      • Different phases of Modeling
      • Multi-Dimensional Modeling
      • What is a Dimension?
      • What are Facts?
      • Multi-Dimensional Model
      • Hierarchies
      • OLAP
      • MOLAP
      • ROLAP
      • HOLAP
      • Cubes and its Functions
      • Star Schema
      • Fact Table
      • Dimensional Tables
      • Snow flake Schema
      • Factless Fact Table
      • Confirmed Dimensions
    • What is ETL?
    • Why we need ETL in Data Warehousing?
    • ETL Architecture?
    • Meta Data?
    • Extraction?
      • Source Tables
      • Types of Sources
        • Database
        • Flat files
      • Transformation
      • Why we need Transformation, importance transformation?
      • Importance of Data Integration?
      • Loading, types of loading?
        • Full Load
        • Incremental Load
        • Stage Loading
        • DIM Loading
        • Fact Loading
        • AGG Fact Loading
        • Dependencies while loading
      • Deferent Targets?
      • Repository
        • Metadata
        • Where Meta Data is storing?
        • Why we need repository?
        • MDM – Meta Data Management
        • How to maintain repository?
        • Global Repository
      • ETL Tools Informatica Power Center
        • Introduction to Informatica
        • Server Components
          • Informatica Admin Console
            • Configuring Repository Services
            • Configuring Integration Services
            • Backing up the repository
          • Restoring Repositories
          • Running Modes
            • Normal Mode
            • Exclusive Mode
        • Client Components
          • Repository Manager
          • Mapping Designer
            • Source Analyzer
            • Target Analyzer
            • Transformation Developer
            • Mapplet Designer
            • Mapping Designer
          • Workflow Designer
            • Task Developer
            • Worklet Designer
            • Workflow Designer
          • Workflow Monitor
            • Usage of Monitor
            • Differences between Stop and Abort
          • Why we need different Client Components in Informatica
        • Informatica Architecture
          • Distributed Services and SOA
          • Domain?
          • Grid?
          • Nodes?
          • Services
            • Repository Services
            • Integration Services
              • Threading Concept in Informatica
              • Types of Threads
            • Repository Agent
          • DTM Process
          • How all server components are architectured for Informatica
    • Transformations
      1. Types of Transformations
        1. Active Transformations
        2. Passive Transformations
        3. Using Functions in Transformations
        4. What is User-Defined Function
      2. Source Qualifier Transformation
      3. Filter Transformation
      4. Expression
      5. Sorter
      6. Router
      7. Ranker
      8. Sequence Generator
      9. Aggregator
        1. Incremental Aggregation
        2. Sorted Input Concept
      10. Joiner
        1. Normal Join
        2. Master Out Join
        3. Detail Out Join
        4. Full Out Join
      11. Update Strategy
      12. Stored Procedure
        1. Connected
        2. Un-Connected
      13. Normalizer
      14. Union
      15. SQL
        1. SQL Mode
        2. Script Mode
      16. Lookup
        1. Connected
        2. Un-Connected
        3. Cached lookup
          1. Static Cache
          2. Dynamic Cache
          3. Persistence Cache
        4. Un-Cached lookup
      17. Transaction Control
      18. Other Advanced Transformations
    • How to create a simple mapping?
    • How we can do integration with informatica?
    • Parameters and Variables
    • Concept of Generic Code and how to make Generic Coding in Informatica
    • Usage of Parameterization
    • Creating Parameter Files
    • Creating Mappings for different scenarios
      1. Implementing SCD Type-1
      2. Implementing SCD Type-2
      3. Implementing SCD Type-3
      4. Extracting data from different sources using informatica
        1. DBs
        2. Flat Files
    • Excel Sheets and others
    1. Other Scenarios
    • Task
      1. Type of Tasks
      2. Sessions
      3. Command Task
      4. E-Mail Task
      5. Decision
      6. Event – Wait
      7. Event – Raise
      8. Timer
      9. Assignment
      10. Control
    • Worklet
      1. How to create worklets
      2. Use of worklets
    • Workflows
      1. Use of workflow
      2. How to create workflows
    • Connections
      1. What is connections
      2. Types of connections
        1. Relational Connections
        2. FTP Connections
    • Other Connections
    • Invoking Workflow from Command line
      1. pmrep commands
      2. pmcmd commands
      3. encrypting Informatica Passwords for scripts
    • Scheduling
    • Link Conditions
    • Other Advanced Topics
      1. Versioning
      2. Partitioning
    • Environments
      1. Development
      2. QA
      3. UAT
      4. Production (Live)
      5. Migration Process
        1. Importing
        2. Exporting
      6. Role of Unix Shell scripting in ETL process

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.