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
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
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
- Create Project
- Delete Project
- Protect Project
- Environmental variables
- Auto purge
- RCP
- OSH
- Commands Execute
- Multiple Instances
- Job Sequence Settings
- Introduction to data stage director
- Job status view
- View logs
- Scheduling
- Batches creation
- 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
- 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
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