DATASTAGE Online Training in USA

DATASTAGE Online Training

DATASTAGE Online Training
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

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim