Datastage Online Training

Course Details:
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

SBR Trainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. SBR come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.

SBR trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.

SBRTrainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. SBR come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.

SBR trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.

1. The classes can be attended to at any place and any time as per your choice Use your laptop, desktop, Android and iOS App to learn on the go
2. Choose from a number of batches as per your convenience If you got something urgent to do, reschedule your batch for a later time if you want fast rack also arrange 1:1
3. Live screen sharing, step-by-step live demonstrations and live Q&A led by real time industry experts. If you are busy so not joined class it means Missed a class? Not an issue. We record the classes and send to your email id
4. Share your learning objectives and get oriented with our web and mobile platform. Talk to your personal learning manager to clarify your doubts
5. We have pre-populated your learning platform with previous class recordings and presentations.
6. We have in-house expert Teaching Assistants to resolve all your queries. Reach out to us by raising a ticket from your learning platform. sbrtrainings provides life time learning assistance.
7. Have a problem? Our Support Ninjas Are There to Help You 24 X 7

ENQUIRY FORM HERE :
Back to top