Radical Technologies
  • News Update: - AWS Solution Architect Exam - Get 50 % Off before April 10th 2017.....Vmware VCP 6.0 + 6.5 Combo on High End Cisco UCS Servers ...Openstack Version 8.0 New Batch Registration Started ....Bigdata Hadoop - Experience Our Expertise ... Real 16 Node Hadoop Cluster Build on Amazon Cloud... Available Discounted Oracle Global Certification Vouchers...Aws , Salesforce, RHCSA , RHCE Sure Shot Exam Preparation Sessions....Mastering Devops .......Chef+Puppet+Docker+Ansible + Salt Stack + Jenkins +Git +Nagios +Jira......ServiceNow Combo.... Admin + Scripting and Implementation + Advanced administration.....Oracle Exadata Training on High End Cisco UCS Servers ....Congratulations to All RHCSA and RHCE Certified Students- Next RHCSA and RHCE Exam date- April 30th 2017.
  • COMBO COURSES

    RedHat Linux, Vitualization, Cloud, Hadoop,Datawarehousing Combo Courses with Discounted Price.....

    Readmore..

  • ONLINE TRAINING

    Radical Technologies provides best Online Training with Real-time Projects by Industry Experts....

    Online Schedule

  • BATCH SCHEDULE

    Best Classroom Training from Industry Consultants on High end Real-time Enterprise servers...

    Classroom Schedule

  • CERTIFICATIONS

    Authorized Exam Center for RedHat, Oracle, IBM, Microsoft, Cisco, Salesforce, AWS etc...

    Readmore..

DATASTAGE 8.5

Best Training IBM WebSphere DataStage   8.5

Duration of  Training : 6 weekends

Trainer is having 10 + years of experience in IT Industry.

——————————————————————————————————————————–

SYLLABUS
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 Modelling
Introduction to Data Modelling – Entity Relationship model (E-R model) – Data Modelling for Data Warehouse – 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: Data Stage Installation
Data stage Installation – Prerequisites to install Data stage – Installation process.

Unit – 5: Introduction to DataStage Version 8.5
DataStage introduction – IBM information Server architecture –– DataStage components – DataStage main functions – Client components.

Unit – 6: DataStage Administrator
DataStage project Administration – Editing projects and Adding Projects – Deleting projects Cleansing up project files – Global variable setting – Environment management – Auto purging – Rutime Column Propagation(RCP) – Add checkpoints for sequencer – NLS configuration – Generated OSH (Orchestrate Engine) – System formats like date, timestamp – Project protect – Version details.

Unit – 7: DataStage Director
Introduction to DataStage Director – Validating DataStage Jobs – Executing DataStage jobs – Job execution status – Monitoring a job – Job log view – job scheduling – Creating Batches – Scheduling batches.

Unit – 8 : DataStage Designer
Introduction to DataStage Designer – Importance of Parallelism – Pipeline Parallelism – Partition Parallelism – Partitioning and collecting – Partition techniques – DataStage Repository Palette –
Passive and Active stages – Job design overview – Designer work area – Annotations – Creating jobs – Importing flat file definitions – Dataset Overview

Unit – 9: Working with Parallel Job Stages
Database Stages
Oracle – Teradata – ODBC – dynamic RDBMS – DB2
File Stages
Sequential file – Dataset – File set – Lookup file set.
Processing Stages
Copy – Filter – Funnel – Sort Remove duplicate – Aggregator – Modify – Compress – Expand – Decode – Encode – Switch – Pivot stage – Lookup – Join – Merge – difference between look up, join and merge – change capture – Change apply – Compare – Difference – Surrogate key generator – Transformer.
Debug Stages
Head – Tail – Peek – Column generator – Row generator.
Real Time Stages
XML input – XML output –XML Transformer, Java packs, Webservice packs
Local and Shared containers

Unit – 10 Advanced Stages in Parallel Jobs (Version 8.5)
Range Look process – Surrogate key generator stage – Slowly changing dimension stage – iway stage – FTP stage – Java plug in – Job performance analysis – Resource estimation – Slowly Changing Dimensions implementation – Performance tuning.

Unit – 11 Job Sequencers
Arrange job activities in Sequencer – Triggers in Sequencer – Restablity – Recoverability – Notification activity – Terminator activity – Wait for file activity – Start Look activity – Execute Command activity – Nested Condition activity – Exception handling activity – User Variable activity – End Loop activity – Adding Checkpoints

Unit – 12 Information Analyzer
IBM WebSphere Information Analyzer overview – Data Profiling process – Column analysis – Primary key analysis – Foreign key analysis – Cross-domain analysis – Baseline analysis – Aanalysis result publication – Deleting statistics reports – Baseline analysis reports – Cross-domain analysis summary statistics reports – Beseline analysis reports – Cross-domain analysis reports – Primary key reports – Foregin key analysis reports.

Unit – 13 WebSphere Quality Stage
About Data Quality – DataStage quality stages – Investigate stage – Standardize stage Match Frequency stage – Unduplicate Match stage – Reference Match Stage – Survive stage.

Unit – 14 IBM Information Server Administration Guide
IBM WebSphere DataStage administration – Opening the IBM Information Server Web console – 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.