IBM DATASTAGE TRAINING

An Introduction of Data warehousing
Purpose of Data warehouse
Data ware Architecture
OLTP vs. Data warehouse Applications
Data Marts
Data warehouse Lifecycle
SDLC

Introduction of Data Modeling
Entity Relationship Model
Dimensions and Fast Tables
Logical and Physical Modeling
Schemas like Star Schema & Snowflake Schemas
Fact less Fact Tables

Introduction of Extraction, Transformation and Loading
Types of ETL tools and Key tools in the market

Windows server, Oracle, .NET and Data stage 7.5X2 & 8x

Server jobs & Parallel jobs

Administrator, Designer and Director client
Import/export and Multi-client manager
Console and Web console for IBM information server

Data stage Introduction
IBM Information server Architecture
IBM Data Quality Architecture
Enterprise Information Integration
Web Sphere Data Stage Components

About Web Sphere Data Stage Designer
Partitioning Methods and 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)
OSH Importing Method
Configuration file

DATABASES STAGES
Oracle Database
Dynamic RDBMS
ODBC
SQL Server
Teradata

Sequential File
Dataset
Lookup File set
Peek, Head and Tail
Row and Column Generator
Slowly changing dimension stage and dimensions implementation
Aggregator, Copy, Compress, Expand, Filter, Modify, Sort
Switch, Lookup, Join, Marge
Change Capture and Change Apply
Compare, Difference, Funnel
Remove Duplicate and Surrogate Key Generator
Pivot stage, Transformer

Shared and Local Containers
About DS Director
Validation, Scheduling
Status, View logs
Monitoring
Suppress and Demote the Warnings
Peek view

Create, Delete and Protect Project
Environmental variables
Auto purge
RCP and OSH
Commands Execute
Multiple Instances
Job Sequence Settings

Job Activity and Job sequencer
Start loop and End loop Activity
Notification and Terminator Activity
Nested Condition and Exception handling Activity
Execute Command, Wait for file and User variable Activity
Adding Check Points and Restart able

Data Quality and Data Quality Stages
Investigate, Standardize and Match Frequency Stage
Reference and Unduplicated Match Stage, Survive Stage
Viewing audit details in operational DASHBOARD reports

Our trainers are Highly experienced in IBM DATASTAGE implementing real-time solutions on different Scenarios and Expert in their professionals.

We record each LIVE class session you undergo through this training and we will share the recordings of each session/class.

Trainer will Provide Detailed installation of required software through LMS to the students we support by providing Training and practical in real time experience with all utilities required for completely understanding of this Training.

Yes, there are some group discount are available only if group contain more than 2 Or more participates.

Basic Hard ware requirement is useful to install the Product

We provide Training in a Real Time Projects Oriented

Yes we will Schedule a Demo Session as per the student convenient by sharing LIVE Online Streaming access either through GoToMeeting or WebEx.

If you are enrolled in classes and you have paid fees, but want to cancel the registration for certain reason, it can be done within 48 hours of initial registration. Please make a note that refunds will be processed within 15 days of prior request

As we are one of the Best IBM DATASTAGE Online Training Provider we have customer throughout the world wide specially from UK, USA, UAE, Australia, Qatar, Singapore, New Zealand, India, Malaysia, Dubai, Doha, Melbourne, Brisbane, Perth, Wellington, Auckland Middle East Countries and other parts of the world

We are also located in USA Offering IBM DATASTAGE Online Training in Cities like New York, New jersey, Dallas, Seattle, Baltimore, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, Washington DC, Chicago, Philadelphia, St. Louis, Edison, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Atlanta, Alexandria, Sunnyvale, Santa Clara, Carlsbad, San Marcos, Franklin, Tacoma, California, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert.

In India we have customer from Bangalore, Mysore, Hyderabad (Ameerpet), Visage, Chennai, Kolkata, Pune, Mumbai, Delhi, Jaipur, Ahmadabad, Kerala etc…

You can clarify your queries by dialing +91 - 82 9696 0414, +1 (646) 586 - 2969 Or you can send a mail to info@gologica.com. We are ready to clear your enquiries at any time