Overview:

About Datastage

A datastage is basically a tool that is used to design, develop and execute various applications to fill multiple tables in data warehouse or data marts. It is a program for Windows servers that extracts data from databases and change them into data warehouses. It has become an essential part of IBM WebSphere Data Integration suite.

Overview of Datastage training

SBRtrainings One of the best institute for Datastage online training in hyderabad come up with New and innovative teaching methodologies to make the learning process easier.The entire course curriculum of Datastage designed to meet industry requirements. Flexibility, availability, and conveniences are the three key aspects of our online training pattern. Our training helps students to learn real time concepts of Datastage. the learning process in sbrtrainings is very fun and practical.

Datastage Course Objectives

The student will be able handle all the core components of the Data stage course
BM Information server Overview & Architecture
Websphere Datastage Usability Improvements
Best in class Data Transformation
Focus on Connectivity
Installation,Configuration,Administration,Reporting
Upgrade to Websphere Datastage v8.0


Datastage Course Content:
DATA WAREHOUSE FUNDAMENTALS
An Introduction of Data warehousing
purpose of Data warehouse
Data ware Architecture
OLTP Vs Data warehouse Applications
Data Marts
Data warehouse Lifecycle
DLC
DATA MODELING
Introduction of Data Modeling
Entity Relationship Model
Dimensions and Fast Tables
Logical Modeling
Physical Modeling
Schemas Like Star Schema & Snowflake Schemas
Fact less Fact Tables
PROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD)
Introduction of Extraction , Transformation and Loding
Types of ETL tools
Key tools in the market INSTALLATION PROCESS
Windows server
Oracle
.NET
Datastage 7.5X2 & 8x
DIFFERENCE
Server jobs & Parallel jobs
COMPONENTS IN DATASTAGE
Administrator client
Designer client
Director client
Import/export manager
Multi client manager
Console for IBM imformation server
Web console for IBM imformation server
INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X
Datastage Introduction
IBM Information server Architecture
IBM Data Quality Architecture
Enterprise Information Integration
Web Sphere DataStage Components
DATASTAGE DESIGNER
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)
OSH Importing Method
Configuration file
PARALLEL PALETTE
DATABASES STAGES
Oracle Database
Dynamic RDBMS
ODBC
SQL Server
Teradata
FILE STAGES
Sequential File
Dataset
Lookup File set
DEV/DEBUG STAGES
Peek
Head
Tail
Row Generator
Column Generator
PROCESSING STAGES
Slowly changing dimension stage
Slowly changing dimensions implementation
Aggregator
Copy
Compress
Expand
Filter
Modify
Sort
Switch
Lookup
Join
Marge
Change Capture
Change Apply
Compare
Difference
Funnel
Remove Duplicate
Surrogate Key Generator
Pivot stage
Transformer
CONTANERS
Shared Containers
Local Containers
DS-DIRECTOR
About DS Director
Validation
Scheduling
Status
View logs
Monitoring
Suppress and Demote the Warnings
Peek view
DATASTAGE ADMINISTRATOR
Create Project
Delete Project
Protect Project
Environmental variables
Auto purge
RCP
OSH
Commands Execute
Multiple Instances
Job Sequence Settings
JOB SEQUENCE AREA
Job Activity
Job sequencer
Start loop Activity
End loop Activity
Notification Activity
Terminator Activity
Nested Condition Activity
Exception handling Activity
Execute Command Activity
Wait for file Activity
User variable Activity
Adding Check Points
estartable
IBM WEB SPHERE QUALITY STAGE
Data Quality
Data Quality Stages
Investigate Stage
Standardize Stage
Match Frequency Stage
Reference Match Stage
Unduplicated Match Stage
Survive Stage
Viewing audit details in operational DASHBOARD reports
KEY SERVICE
FAQS
Covering DBA concepts
Concentration on performance tuning
Real time scenarios Certification guidance
Resume preparation
Sample resumes
Interview & certification FAQS
How to face the interview
Class notes which is useful for who is trying for job
Project preparation

FAQ

1. How does the Online training work and Where do I go to access the online training?
All of our online courses are live instructor-led online courses .Course training is conducted through high-quality online technologies like webex,go to meeting.after registration of the course,access details and link will be given to the students.
2.how much internet speed is required to access online course?
1 mb internet speed is enough To access the online live classes.most of the students are access online training with low internet speed
3.Can I get recorded sessions as a material ?
Yes.we will provide all recorded session which you have done in previous classes on live session .complete practical guide and recorded sessions will be given with material.
4.Can I interact with course instructors?
Yes you can interact with instructors via phone or email to clarify you regarding subject also we provide 24/7 live support to our students.
5. what happen if I miss my training classes?
If any student missed any class.we will provide recorded session as a backup session and if you have any doubts regarding missed session our instructors will clarify on the spot.
6.will I get job assistance?
Yes we will provide job assistance for our students after completion of your course our instructors and career counselors will guide you till the student got placed .
7.is there any discount and offers I can avail?
We will not consider it is a business hence We provide all courses at reasonable prices .you can compare with others.even though our courses are very affordable we will some give discounts on selected courses.
8.who are the trainers?
We have 10+experience ,high qualified and certified trainers with industry expert.they are very knowledgeable in their core domains.
9.can I attend a Demo session?
Yes you can attend our demo session after you enroll the course completely it is free of cost and if you miss the demo we will provide prerecorded demo sessions recorded by our experts our experts
10.what are the payment options?
You can pay by credit card,debit card and net banking from all leading banks,for USD payments,you can pay by PayPal.
11.what if I have more queries?
You can give us a call at +91 9494347041 or email at contact@sbrtrainings.com

Online Datastage Demo Training

Datastage Course Duration

Online Training
It is a 35 to 40 Hours program and extends up to 2hrs each Day.
Corporate Training
It is a 6 days program and extends up to 8hrs each.
Classroom Training
Private Classroom arranged on request and minimum attendies for batch is 4.