Data Stage Online Training|Support

[training21]

Selfpacedtech is the best Online Training provider worldwide with real time experts :

Data Stage  Course Content :

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

Contact US : 309 - 200 - 3848 / 2019051656 / +91 9030990003