DATASTAGE Online Training in USA
DATASTAGE Online Training
DATASTAGE Online Training Course Content :
DATA WAREHOUSING CONCEPTS
- History of Data warehouse
- Need of a Data warehouse
- OLTP Systems
- Definition of Data warehouse
- Difference b/w OLTP & DW
- Data-warehousing Architecture
- Data warehouse Vs. Data mart
- Data-warehousing Approaches
- Dimension Tables & Types
- Slowly changing Dimension-Type1
- Type 2 and Type 3
- Conformed Dimension
- Lately Arriving Dimension
- Junk Dimension
- Degenerated Dimension
- Dirty Dimension
- Fact Table & types
- Measures & facts
- Types of Facts
- Data-warehousing Schema s
- Data Acquisition Process
- Project Life Cycle
- Extraction types
WEBSPHERE DATA STAGE AND QUALITY STAGE
- Introduction to Web sphere Data stage & Quality Stage
- Parallel Processing
- Pipeline parallel processing
- Partition parallel processing
- Difference b/w Informatica & Data Stage
- Information Server Architecture
WEBSPHERE DATA STAGE AND QUALITY STAGE DESIGNER
- Introduction to Data stage Designer
- Metadata Repository
- Palette
- General Stages
- Data Quality
- Investigate Stage
- Match Frequency
- MNS
- Standardize Stage
- Unduplicate Match
- WAVES
- Survive Stage
- File Stages
- Database Stages
- Informix Stage
- Classic Federation
- IWay Enterprise
- Netteza Enterprise
- Development/Debug Stages
- Processing Stages
- FTP Stage
- Transformer Stage
- Slowly Changing Dimension Stage
- Websphere TX Map
- Real Time Stages
- Web services Client
- Web services Transformer
- WISD Input
- WISD Output
- XML input
- XML Output
- XML Transformer
- Websphere MQ
- Java Client
- Java Transformer
- SAP Plug-In Stages
- ABAP Stage
- IDoc Extract Stage
- IDoc Load Stage
- BAPI Stage
- Restrecture Stages
- Buildop Stages
- Exporting the DS Components
- Importing the DS Components
- Managing the Repository
- Data Set Management Utility
- Message Handler for Manager
- Performance Analysis
- Resource Estimation
WEBSPHERE DATA STAGE AND QUALITY STAGE DIRECTOR
- Introduction to Data stage Director
- Validation of Data Stage Jobs
- Run, Stop, Reset, Kill, and Unlock the DS Jobs
- Scheduling the DS Jobs
- Debugging
- Saving Log into a File
- Creation of Batch jobs
- Monitoring the DS Jobs
- View status, Job Log, Schedule Logs
WEBSPHERE DATA STAGE AND QUALITY STAGE ADMINISTRATOR
- Introduction to Administrator
- Adding & Deleting a Project
- Cleaning the Project Files
- Changing & upgrading the license
- Auto Purging
- NLS Configuration
- Share Metadata when importing connections
- Protection of DS Projects
- Set Environmental Variables
- Set permissions to USERS
- Enable RCP
WEBSPHERE INFORMATION ANALYZER
- Data quality Assessment Methodology
- IBM Web sphere Information Analyzer Architecture
- Column Analysis
- Primary Key Analysis
- Foreign Key Analysis
- Cross Domain Analysis
- Publish Analysis Results
- IBM Web sphere Audit Stage Business Rule Validation
- Baseline Analysis
- Reports
- Migration of Data stage Jobs 7×2 to 8.0.1
- Webs phere Information Services Director (WISD)
JOB SEQUENCE
- Introduction to Sequencer
- Arrange Job Activities in Sequencer
- Triggers in Sequencer
- Job Activity Stage
- Notification Activity Stage
- Wait-for-file Activity Stage
- Routine Activity
- Add Check Points
- Terminate Activity
- User Variable Activity
- SCD IMPLIMENTATION
- Performance Tunning in Parallel Jobs
Serjobs jobs
mapping sheet analysis
Unittesing docs
Deployment docs
Increment loading designing + SCD’s + Facttable loading.
Drop your query
Most Popular Courses
Achieve your career goal with industry recognised learning paths
What my Client's Say?
-
It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand
-
All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin
-
It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla
-
Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig
-
Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala
-
It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar
-
The course was really good because it was a practical course.~ M.Radha patel
-
I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria
