 |
|
|
|
|
|
|
Classifieds: Education / Training | | Datastage online training | | Posted By: nipuna onlinetraining at: 14, Jun 2012 0:28:04 AM IST |
Data Stage
STEP-1 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
• SDLC
STEP-2 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
Visit Us
http://nipunaonline.com/
Email ID : info@nipunaonline.com
Email ID : nipunaonlinetraining@gmail.com
Skype ID : nipunaonline@skype.com
Contact us
India : +91 789 300 5400
USA : + 01 985 400 3134
STEP-3 PROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD)
• Introduction of Extraction , Transformation and Loding
• Types of ETL tools
• Key tools in the market
STEP-4 INSTALLATION PROCESS
• Windows server
• Oracle
• .NET
• Datastage 7.5X2 & 8x
STEP-5 DIFFERENCE
• Server jobs & Parallel jobs
STEP-6 COMPONENTS IN DATASTAGE
• Administrator clint
• Designer client
• Director client
• Import/export manager
• Multi client manager
• Console for IBM imformation server
• Web console for IBM imformation server
STEP-7 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
STEP-8 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
STEP-9 PARALLEL PALETTE
• DATABASES STAGES
o Oracle Database
o Dynamic RDBMS
o ODBC
o SQL Server
o Teradata
• FILE STAGES
o Sequential File
o Dataset
o Lookup File set
• DEV/DEBUG STAGES
o Peek
o Head
o Tail
o Row Generator
o Column Generator
• PROCESSING STAGES
o Slowly changing dimension stage
o Slowly changing dimensions implementation
o Aggregator
o Copy
o Compress
o Expand
o Filter
o Modify
o Sort
o Switch
o Lookup
o Join
o Marge
o Change Capture
o Change Apply
o Compare
o Difference
o Funnel
o Remove Duplicate
o Surrogate Key Generator
o Pivot stage
o Transformer
CONTANERS
• Shared Containers
• Local Containers
STEP-10 DS-DIRECTOR
• About DS Director
• Validation
• Scheduling
• Status
• View logs
• Monitoring
• Suppress and Demote the Warnings
• Peek view
STEP-11 DATASTAGE ADMINISTRATOR
• Create Project
• Delete Project
• Protect Project
• Environmental variables
• Auto purge
• RCP
• OSH
• Commands Execute
• Multiple Instances
• Job Sequence Settings
STEP-12 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
• Restartable
STEP-13 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
|
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
