Datastage Online Training

 

 

Data Stage  Online Training by Real Time expert @ Good Online Training.

 

www.goodonlinetraining.com

info@goodonlinetraining.com

+91 996 395 7366     

Email : knaveen.sas@gmail.com

Email : info@goodonlinetraining.com

 

Data Stage Online Training Course Content:

Definition of: DataStage



A data extraction and transformation program for Windows NT/2000 servers that is used to pull data from legacy databases, flat files and relational databases and convert them into data marts and data warehouses. Formerly a product from Ascential Software Corporation, which IBM acquired in 2005, DataStage became a core component of the IBM WebSphere Data Integration suite. we provid more information from below.

Introduction to DATASTAGE

• What is datastage?
• Difference between server jobs and parallel jobs
• Difference between pipeline parallelism and partition parallelism
• Partition techniques (round robin, random, hash, entire, same, modules, range, DB2, auto)
• Collecting Techniques (Auto, sortmerge, ordered)
• Configuration file
• Difference between SMP/MPP architecture
• Data stage components (server components/client components)
• Package installer

DATASTAGE ADMINISTRATOR

• Create Project
• Delete Project
• Protect Project
• Environmental variables
• Auto purge
• RCP
• OSH
• Commands Execute
• Multiple Instances
• Job Sequence Settings

 Data stage director:

• Introduction to data stage director
• Job status view
• View logs
• Scheduling
• Batches creation

Data stage Designer:

• About Web Sphere DataStage Designer
• Partitioning Methods
• Partitioning Techniques
• Designer Canvas
• Central Storage
• Job Designing
• Creating the Jobs
• Compiling and Run the Jobs
• Exporting and importing the jobs
• Parameter passing
• System(SMP) & Cluster system(MPP)
• Importing Method(Flat file, Txt, Xls and Database files)
• OSHImporting Method
• Configuration file

Processing stage:

• Aggregator
• Change apply
• Change capture
• Compare
• Compress
• Copy
• Decode
• Difference
• Encode
• Expand
• External filter
• Filter
• FTP
• Funnel
• Generic
• Join
• Lookup
• Merge
• Difference between join/lookup
• Difference between join/lookup/merge
• Modify
• Pivot
• Remove duplicates
• Slowly changing dimension
• Sort
• Surrogate key generator
• Switch
• Transformer
• Websphere TX Map
• Transformer stage
• Surrogate generator stage
• Join generator stage
• Merge generator stage
• Look up generator stage
• Debugging stage
• Head
• Tail
• Peak
• Row generator
• Column generator
• Sample
• Job parameters
• PARAMETER SETS
• SLOWLY CHAMGING DIMENSIONS
• Sequencer
• Importing the job
• Exporting the job
• Importing table definition
• Importing flat file definition
• Containers
• Difference between local container and shared container
• Local container
• Shared container

 

 

 

http://goodonlinetraining.com/data-warehousing/data-stage-online-training /

 

We do provide Online training on the following Technologies:

 

 

 

DATA WAREHOUSING

Informatics

Data Stage

Business Objects XIR3

Ab Initio

Cognos BI

Cognos Planning, and Data manager,

CognosTM1

Cognos Metric studio and Designer

SAP-BI-BO WITH (INTEGRATION)

XCELSIUS, LIVEOFFICE, CRYSTALREPOT

BODI 11.7/11.5 OR Sap-Data service XI 3.2

Teradata Developer

SAP (All Modules)

SAP BI7.0, SAP-security basics

SQL Server DBA AND Developer

SQL SERVER 2008 MS-BI (SSIS,SSAS,SSRS)

Oracle DBA

Oracle SQL/PLSQL

OBIEE

ORA

CLE  D2K  ( FORMS AND REPORTS )

PHP

JAVA

Share point 2010

Testing Tools (QTP, MANUEL, RATIONAL)

Oracle Apps

SAS