Topic
  • No replies
ONLINETRAININGS
ONLINETRAININGS
1 Post

Pinned topic Datastage Online Training - Call Us +919000444287

‏2013-08-28T06:39:59Z |

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

Data Modeling

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

ETL Design Process

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

Data Stage Installation

  • Data stage Installation
  • Prerequisites to install Data stage
  • Installation process

Introduction to Data stage Version 8.1

  • Data stage introduction
  • IBM information Server architecture
  • Data Stage component
  • Data Stage main functions
  • Client components

Data stage Administrator

  • Data stage project Administration - Editing projects and Adding Projects
  • Deleting projects Cleansing up project files
  • Global variable setting - Environment management
  • Auto purging - Runtimes Column Propagation (RCP)
  • Add checkpoints for sequencer - NLS configuration
  • Generated OSH (Orchestra Engine) - System formats like data,
  • Timestamp - Project protect - Version details.

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

Data stage Designer

  • Introduction to Data stage Designer - Importance of Parallelism
  • Pipeline Parallelism - Partition Parallelism
  • Partitioning and collecting - Partition techniques
  • Data stage Repository Palette - Passive and Active stages
  • Job design overview - Designer work area
  • Annotations - Creating jobs - Importing flat file definitions
  • Dataset Overview

Working with Parallel Job Stages

  • Database Stages
  • Oracle - Teradata - ODBC - dynamic RDBMS

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, Java packs,
  • Web service packs

Local and Shared containers

Advanced Stages in Parallel Jobs (Version 8.1)

  • Range Look process - Surrogate key generator stage
  • Slowly changing dimension stage - away stage
  • FTP stage - Java plug in - Job performance analysis
  • Resource estimation
  • Slowly Changing Dimensions implementation
  • Performance tuning

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

Online Training institute call us +919000444287
21st Century Software Solutions - We Provide Online Training on all Technologies … - Call Us +917386622889
Visit: 
http://www.21cssindia.com/courses.html
Email : contact@21cssindia.com

 

Attachments

Updated on 2013-08-28T06:41:16Z at 2013-08-28T06:41:16Z by ONLINETRAININGS