Srihitha Technologies

Best Software Training Institute in Ameerpet , Hyderabad

Srihitha Technologies - Best Software Training Institute in Ameerpet , Hyderabad

Datastage Online Training in Ameerpet

Datastage Online Training in Ameerpet

Google+

Srihitha Technologies provides Datastage Online Training in Ameerpet by real time Experts. For more information about Datastage online training in Ameerpet call 9885144200 / 9394799566.

Unit -1: Data Warehouse Fundamentals

  • An introduction to Data Warehousing
  • Purpose of Data Warehouse
  • Data Warehouse Architecture
  • Operational Data Store
  • OLTP Vs Warehouse Applications
  • Data Marts
  • Data marts Vs Data Warehouses
  • Data Warehouse Life cycle.

Unit -2: Data Modeling

  • Introduction to Data Modeling
  • Entity Relationship model (E-R model)
  • Data Modeling for Data Warehouse, Normalization process
  • Dimensions and fact tables
  • Star Schema and Snowflake Schemas.

Unit -3: ETL Design Process

  • Introduction to Extraction, Transformation & Loading
  • Types of ETL Tools
  • Key tools in the market.

Unit – 4: Introduction to Data stage Version 7.5×2 & 8.1& 8.5

  • Data stage introduction
  • IBM information Server architecture
  • Data stage components
  • Data Stage main functions
  • Client components- Adding different Servers to our workspace.

Unit – 5:  Data stage Administrator

  • Data stage project Administration
  • Editing projects and Adding Projects
  • Deleting projects Cleansing up project files
  • Environmental Variables
  • Environment management
  • Auto purging
  • Runtime Column Propagation(RCP)
  • Add checkpoints for sequencer
  • NLS configuration
  • Generated OSH (Orchestra Engine)
  • System formats like data, timestamp
  • Projects protect – Version details.

Unit – 6:  Data stage Director

  • Introduction to Data stage Director
  • Validating Data stage Jobs
  • Executing Data stage jobs
  • Job execution status
  • Monitoring a job
  • Job log view
  • Job scheduling
  • Creating Batches
  • Scheduling batches.

Unit – 7:  Data stage Designer

  • Introduction to Data stage Designer
  • Importance of Parallelism
  • Pipeline Parallelism
  • Partition Parallelism
  • Partitioning and collecting(In depth coverage of partitioning and collective techniques)
  • Symmetric Multi Processing (SMP)
  • Massively Parallel Processing (MPP)
  • Introduction to Configuration file
  • Editing a Configuration file
  • Partition techniques
  • Data stage Repository Palette
  • Passive and Active stages
  • Job design overview
  • Designer work area
  • Annotations
  • Creating jobs
  • Importing flat file definitions
  • Managing the Metadata environment
  • Dataset management
  • Deletion of Dataset
  • Routines

Unit – 8:  Working with Parallel Job Stages

  • Database Stages
    • Oracle
    • ODBC
    •  Dynamic RDBMS
  • File Stages
    • Sequential file
    • Dataset
    • File set
    • Lookup file se
  • Processing Stages
    • Copy
    • Filter
    • Funnel
    • Sort
    • Remove duplicate
    • Aggregator
    • Switch
    • Pivot stage
    • Lookup
    • Join
    • Merge
    • Difference between look up, join and merge
    • Change capture
    • External Filter
    • Surrogate key generator
    • Transformer
  • Real time scenarios using different Processing Stages – Implementing different logics using Transformer
  • Debug Stages
    • Head
    • Tail
    • Peek
    • Column generator
    • Row generator
    • Write Range Map Stage
  • Real Time Stages
    • XML input
    • XML output
  • Local and Shared containers
  • Routines creation
  • Extensive usage of Job parameters, Parameter Sets, Environmental variables in jobs
  • Introduction to predefined Environmental variables creating user defined Environmental variables and implementing the same in parallel jobs

Unit – 9:  Advanced Stages in Parallel Jobs (Version 8.1)

  • Explanation of Type1 and Type 2 processes
  • Implementation of Type1 and Type2 logics using Change Capture stage and SCD Stage
  • Range Look process
  • Surrogate key generator stage
  • FTP stage
  • Job performance analysis
  • Resource estimation
  • Performance tuning

Unit – 10: Job Sequencers

  • Arrange job activities in Sequencer
  • Triggers in Sequencer
  • Restablity
  •  Recoverability
  • Notification activity
  • Terminator activity
  • Wait for file activity
  • Start Loop activity
  • Execute Command activity
  • Nested Condition activity
  • Exception handling activity
  • User Variable activity
  • End Loop activity
  • Adding Checkpoints
  • Jobs used in different real time scenarios.
  • Explanation of Sequence Job stages through different Jobs

Unit – 11: IBM Information Server Administration Guide

  • IBM Web Sphere Data stage administration
  • Opening the IBM Information Server Web console –
  • Setting up a project ion the console
  • Customizing the project dashboard
  • Setting up security
  • Creating users in the console
  • Assigning security roles to users and groups
  • Managing licenses
  • Managing active sessions
  • Managing logs
  • Managing schedules
  • Backing up and restoring IBM Information Server.

Additional Features

  • Performance Tuning of Parallel Jobs.
  • Data stage Installation process and setup.
  • Project Explanation.