Description
Seller-provided details for this listing.
IBM DATA STAGE
1. Parallel Architecture
Data stage architecture.
SMP , MPP systems
Datastage clients and their usage.
Data partitioning and collectin Techniques.
Parallel execution
Types of Datastage jobs: Overview
2. DataStage Configuration and adminstration
create and configure a project.
Configuration file & its components
Creating Users and assigning roles.
3. MetaData
Orchestrate schema.
methods of importing metadata.
runtime column propagation.
respository functions.
Schema Files
4. Handling data from Files
importing/exporting data to/from framework
sequential file.
usage of CFF ( Complex Flat File)
usage of FileSets and DataSets.
Describe use of FTP stage for remote data.
Identify importing/exporting of XML data.
5. Databases
selection of database stages and database specific stage properties.
Identify source database options.
Target database options.
working with NLS database sources and targets.
6. Data Transformation
Explict/Implict type conversions,
output mappings
selections of Transformer stage vs. other stages.
Transformer stage capabilities
(including: stage variables, link variables, DataStage macros, constraints, system variables, link ordering.)
Identify process to add functionality not provided by existing DataStage stages.
(e.g., wrapper, buildops, user def functions/routines).
7. Job Components
Copy ,modify, filter, switch Stages,
SORT stage.funnel , remove duplicates
Join, Lookup and Merge stages.
Aggregator stage.
change capture/change apply.
Surrogate key generator stage ,SCD stage
Pivot Stage,
8. Job Design
Parameter sets
Visit www.futurepointtech.com for course curriculum
https://www.futurepointtech.com/data-stage-training-in-hyderabad.html
Drop a mail [email protected] we will
1. Parallel Architecture
Data stage architecture.
SMP , MPP systems
Datastage clients and their usage.
Data partitioning and collectin Techniques.
Parallel execution
Types of Datastage jobs: Overview
2. DataStage Configuration and adminstration
create and configure a project.
Configuration file & its components
Creating Users and assigning roles.
3. MetaData
Orchestrate schema.
methods of importing metadata.
runtime column propagation.
respository functions.
Schema Files
4. Handling data from Files
importing/exporting data to/from framework
sequential file.
usage of CFF ( Complex Flat File)
usage of FileSets and DataSets.
Describe use of FTP stage for remote data.
Identify importing/exporting of XML data.
5. Databases
selection of database stages and database specific stage properties.
Identify source database options.
Target database options.
working with NLS database sources and targets.
6. Data Transformation
Explict/Implict type conversions,
output mappings
selections of Transformer stage vs. other stages.
Transformer stage capabilities
(including: stage variables, link variables, DataStage macros, constraints, system variables, link ordering.)
Identify process to add functionality not provided by existing DataStage stages.
(e.g., wrapper, buildops, user def functions/routines).
7. Job Components
Copy ,modify, filter, switch Stages,
SORT stage.funnel , remove duplicates
Join, Lookup and Merge stages.
Aggregator stage.
change capture/change apply.
Surrogate key generator stage ,SCD stage
Pivot Stage,
8. Job Design
Parameter sets
Visit www.futurepointtech.com for course curriculum
https://www.futurepointtech.com/data-stage-training-in-hyderabad.html
Drop a mail [email protected] we will