Sunday, 13 May 2012

Datastage Online Training

Data Stage  Online Training by Real Time expert @ Good Online Training.
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 

No comments:

Post a Comment