Data Stage Integration Tools Training

Data Stage Integration Tools Training

Overview:
Information Stage is a joining apparatus, utilized right now play out the ETL for an information stockroom. It is basically the information Programming interface into the distribution center. UI - normally a business knowledge revealing device it utilizes a graphical documentation to build information joining arrangements and is accessible in various forms, for example, the Server Version, Undertaking Release, and the MVS Edition.

Training Targets of Information STAGE:
This course gives you an unmistakable comprehension about how to utilize Information Stage. Indeed, even a non-programming and IT back ground can get familiar with this Information Stage preparing. It underpins the assortment, change and mix of high volumes of information, with information structures going from easy to profoundly complex.

Target Understudies/Prerequisites:
Information in PCs and comprehension about essential programs.

Course Contents:

Introduction about Information Stage
Difference between Server Employments and Equal Jobs
Difference between Pipeline Parallelisms
Partition strategies (Cooperative effort, Arbitrary, Hash, Whole, Same, Modules,Range,DB2,Auto)
Configuration File
Difference between SMP/MPD architecture
Data Stage Parts (Server segments/Customer Components)
Package Installer

Data Stage Administrator
Creating venture, Altering undertaking and Erasing project
Permissions to user
.Apt Config file
Environment variable creation, permission

Data organize director
Introduction to Information organize Director
Job status View
View logs
Scheduling
Batches Creation

Designer
Introduction about Designer
Repository
Palatte
Types of Links
File Stages
Sequential File
Data set File
Lookup document set
Difference between Consecutive record/Dataset/Document set
Database stages
Dynamic RDBMS
Oracle Enterprise
ODBC Enterprise
Stored Procedure

Processing stages
Change Catch (Caption)
Compare stage
Difference Stage
Aggregate Stage
Transformer Stage
Surrogate Generator Stage
Join Generator Stage
Merge Generator Stage
Lookup Generator Stage
Difference between join/Query/Merge
Difference between join/Lookup
Remove Duplicates
Switch
Pivot
Modify
Funnel

Debugging stage
Head
Tail
Pea
Row Generator
Column Generator
Sample
Job Parameters

Manager
Introduction About Information arrange Manager
Importing the Job
Exporting the Job
Importing Table Definition
Importing Level Document Definition
Routines

Containers
Difference between Nearby Holder and Shared Container
Local Container
Shared Container


datastage