Capacitação privada e/ou personalizada - Deixe a IBM levar o curso a você. Aproveite mais flexibilidade, controle e resultados.
Descrição
| Código | DX444BR | Nível de conhecimento | Básico |
|---|---|---|---|
| Duração | 4.0 Dias | Tipo de entrega | CLASSROOM
(Exercícios práticos) |
| Tipo de curso | Turma Aberta/Fechada | ||
| Preço | BRL R$3.050 incluindo impostos | ||
Learn about the features of IBM WebSphere DataStage V8 and learn how to build and run DataStage Extract, Transform and Load (ETL) jobs.
Learn about DataStage V8 in its IBM Information Server environment. Learn how to build DataStage parallel jobs that read and write data to and from a variety of data stores including sequential files, data sets, and relational tables. Also, learn how to build parallel jobs that process data in a variety of ways: business transformations, data filtering, data combining, data generation, sorting, and aggregating.
Público alvo
This is a basic course for project administrators and ETL developers responsible for data extraction and transformation using DataStage
Pré-requisitos
You should have:
- Knowledge of UNIX or Windows NT administration
- Knowledge of TCP/IP and basic network principles
- Data modeling experience
- Familiarity with Open Database Connectivity (ODBC) and relational database access techniques
Objetivos
- Combine data using lookup, join, and merge stages
- Create jobs that read from and write to sequential files
- Make jobs that read from and write to a relational database using the connector stages
- Build jobs that process data using transformations, combinations, filterings, sortings and aggregations
- Conduct searches and impact analyses
- Produce job reports
- Construct DataStage users
- Administer the DataStage environment
Tópicos principais
- Deployment
- Administration console
- Designer
- Director
- Administrator
- Accessing sequential data
- Retrive relational data using connectors
- Combining data
- Transforming data
- Repository
- Job control
- Metadata
- Parallel framework
- Complex Flat File stage
- Slowly Changing Dimensions
- MQ Connector
- Performance Analyzer and Resource Estimator utilities
