Courses Offered :
Testing Tools      PeopleSoft      Oracle Technologies      SQL DBA / MSBI      DBA/App’s      Data Warehousing      Android / iPhone      OBIEE, Data Stage      SOA Testing      Main Frames      DBA Technologies      SAS      Database / ETL Testing      SAP All Modules      SOA Testing      Micro Soft Technologies      JAVA      

Informatica

    • What is ETL?
    • Why we need ETL in Data Warehousing?
    • ETL Architecture?
    • Meta Data?
    • Extraction?
    • Source Tables
    • Types of Sources
      • Database
      • Flat files
      • Fixed Width
      • Delimited
    • 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

      1. Informatica Admin Console
        1. Configuring Repository Services
        2. Configuring Integration Services
        3. Backing up the repository
          1. Cold Backup
          2. Hot Backup
        4. Restoring Repositories
        5. Running Modes
          1. Normal Mode
          2. Exclusive Mode
      • Client Components
      1. Repository Manager
      2. Mapping Designer
        1. Source Analyzer
        2. Target Analyzer
        3. Transformation Developer
        4. Mapplet Designer
        5. Mapping Designer
      3. Workflow Designer
        1. Task Developer
        2. Worklet Designer
        3. Workflow Designer
      4. Workflow Monitor
        1. Usage of Monitor
        2. Differences between Stop and Abort
      5. Why we need different Client Components in Informatica
      • Informatica Architecture
        • Distributed Services and SOA
        • Domain?
        • Grid?
        • Nodes?
        • Services
        1. Repository Services
        2. Integration Services
          1. Threading Concept in Informatica
          2. Types of Threads
        3. Repository Agent
        • DTM Process
        • How all server components are architectured for Informatica

          • Transformations
            • Types of Transformations

            1. Active Transformations
            2. Passive Transformations
            3. Using Functions in Transformations
            4. What is User-Defined Function
            • Source Qualifier Transformation
            • Filter Transformation
            • Expression
            • Sorter
            • Router
            • Ranker
            • Sequence Generator
            • Aggregator
            1. Incremental Aggregation
            2. Sorted Input Concept
            • Joiner
            1. Normal Join
            2. Master Out  Join
            3. Detail Out Join
            4. Full Out Join
            • Update Strategy
            • Stored Procedure
            1. Connected
            2. Un-Connected
            • Normalizer
            • Union
            • SQL
            1. SQL Mode
            2. Script Mode
            • Lookup
            1. Connected
            2. Un-Connected
            3. Cached lookup
              1. Static Cache
              2. Dynamic Cache
              3. Persistence Cache
            4. Un-Cached lookup
            • Transaction Control
            • 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
                3. Excel Sheets and others
              5. 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
                • What is connections
                • Types of connections
                  • Relational Connections
                  • 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
                      • Development
                      • QA
                      • UAT
                      • Production (Live)
                      • Migration Process
                      1. Importing
                      2. Exporting
                      • Role of Unix Shell scripting in ETL process
Copyright © 2012, Jampani Technologies. All rights reserved.