|
DATAWAREHOUSING CONCEPTS
- History of Data warehouse
- Need of a Data warehouse
- OLTP Systems
- Definition of Data warehouse
- Difference b/w OLTP & DW
- Datawarehousing Architecture
- Data warehouse Vs. Data mart
- Datawarehousing Approaches
- Dimension Tables & Types
- Slowly changing Dimension-Type1
- Type 2 and Type 3
- Conformed Dimension
|
- Lately Arriving Dimension
- Junk Dimension
- Degenarated Dimension
- Dirty Dimension
- Fact Table & types
- Measures & facts
- Types of Facts
- Datawarehousing Schemas
- Data Acquisation Process
- Project Life Cycle
- Extraction types
|
WEBSPHERE DATASTAGE AND QUALITYSTAGE
- Introduction to WebsphereDatastage& Quality Stage
- Parallel Processing
- Pipeline parallel processing
|
- Partition parallel processing
- Difference b/w Informatica& Data Stage
- Information Server Architecture
|
WEBSPHERE DATASTAGE AND QUALITYSTAGE DESIGNER
- Introduction to Datastage Designer
- Metadata Repository
- Palette
- Genaral Stages
- Data Quality
- Investigate Stage
- Match Frequency
- MNS
- Standardize Stage
- Unduplicate Match
- WAVES
- Survive Stage
- File Stages
- Database Stages
- Informix Stage
- Classic Fedaration
- 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 DATASTAGE AND QUALITYSTAGE DIRECTOR
- Introduction to Datastage 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 DATASTAGE AND QUALITYSTAGE 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 Websphere Information Analyzer Architecture
- Column Analysis
- Primary Key Analysis
- Foreign Key Analysis
- Cross Domain Analysis
|
- Publish Analysis Results
- IBM Websphere Audit Stage Business Rule Validation
- Baseline Analysis
- Reports
- Migration of Datastage Jobs 7.5x2 to 8.0.1
- Websphere Information Services Director (WISD)
|
- Intraduction 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+ Facttableloading . |
