Scribd Logo
Upload

Welcome to Scribd!

  • 101 views

    ETL Training Plan

    Uploaded by

    sr_saurab8511
    The document provides an overview of topics and sub-topics related to ETL tools including SSIS and Informatica PowerCenter, along with the number of hours allocated for each. For SSIS, the main topics are introduction/tools (1 hour), ETL components (8 hours), and assignments (8 hours). For Informatica PowerCenter, the topics are where it fits, client/server components, Designer/sources/targets, transformations (12 hours), advanced concepts (2 hours), workflow (2 hours), and monitoring (30 minutes).

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    ETL Training Plan

    Uploaded by

    sr_saurab8511
    101 views5 pages
    The document provides an overview of topics and sub-topics related to ETL tools including SSIS and Informatica PowerCenter, along with the number of hours allocated for each. For SSIS, the main topics are introduction/tools (1 hour), ETL components (8 hours), and assignments (8 hours). For Informatica PowerCenter, the topics are where it fits, client/server components, Designer/sources/targets, transformations (12 hours), advanced concepts (2 hours), workflow (2 hours), and monitoring (30 minutes).

    Original Description:

    good document that explains various steps for etl training in corporate

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides an overview of topics and sub-topics related to ETL tools including SSIS and Informatica PowerCenter, along with the number of hours allocated for each. For SSIS, the main topics are introduction/tools (1 hour), ETL components (8 hours), and assignments (8 hours). For Informatica PowerCenter, the topics are where it fits, client/server components, Designer/sources/targets, transformations (12 hours), advanced concepts (2 hours), workflow (2 hours), and monitoring (30 minutes).

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    101 views5 pages

    ETL Training Plan

    Uploaded by

    sr_saurab8511
    The document provides an overview of topics and sub-topics related to ETL tools including SSIS and Informatica PowerCenter, along with the number of hours allocated for each. For SSIS, the main topics are introduction/tools (1 hour), ETL components (8 hours), and assignments (8 hours). For Informatica PowerCenter, the topics are where it fits, client/server components, Designer/sources/targets, transformations (12 hours), advanced concepts (2 hours), workflow (2 hours), and monitoring (30 minutes).

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    Sr. No. Topic Sub-topic No.

    of hours
    Introduction and tools 0.5
    1 ETL
    Key Terms 1.5
    Introduction 0.5
    Architecture & UI 2
    Components of SSIS: Data Flow 3
    2 SSIS Components of SSIS: Control Flow 2
    Logging 2
    Error Handling & Debugging 2
    Deployment, Scheduling and Package
    Execution 2
    MCQs on Basic Concepts 0.5
    3 Assignments Case Study 1 4
    Case Study 2 4
    Sr. No. Topic

    1 Where PC fits in

    2 Power Center Client and Server Components

    Designer, Sources, Target


    3

    4 Transformations

    5 Advanced concepts
    5 Advanced concepts

    6 Workflow

    7 Monitor
    Sub-topic No. of hours
    PC IDQ MDM 10 minutes
    Designer

    Repository Manager

    Workflow Manager

    Workflow Monitor

    Administrator

    Repository Services

    Integration Services 1 Hour


    Flat files( CSV, TXT) 30 minutes
    Relational (Oracle, SQL) 15 minutes
    Expression Transformation

    Lookup Transformation (Static


    LookUp Cache
    Dynamic LookUp Cache
    Persistence lookup Cache)

    Sequence Generator
    Transformation
    Filter Transformation

    Joiner Transformation

    Sorter Transformation 6 Hours


    Router Transformation

    Aggregator Transformation

    Update Strategy Transformation

    Union Transformation

    Rank Transformation

    Normalizer Transformation

    Source Qualifier Transformation

    Stored Procedure Transformation


    Unconnected lookup
    Transformation
    Mapplet and Types of Mapplets

    2 hours
    Target Load Plan
    2 hours
    Mapping Parameters

    Mapping Variables
    Difference Between Normal and
    Bulk Loading
    Session

    Command

    EMAIL

    Timer

    Event Wait

    Event Raise 6 hours

    Decision

    Assignment

    Control

    Connections

    Scheduling Work flow

    Monitoring

    Charts 30 minutes

    Log interpretation

    You might also like