Download - Data stage Online Training
![Page 1: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/1.jpg)
Data Stage – 8 Online Training
Glory IT Technologies
![Page 2: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/2.jpg)
Prerequisites
Knowledge of the Windows OSFamiliarity with Open Database
Connectivity (ODBC) and relational database access technique
![Page 3: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/3.jpg)
1. DATA WAREHOUSE FUNDAMENTALS
An Introduction of Data warehousingpurpose of Data warehouseData ware ArchitectureOLTP Vs Data warehouse ApplicationsData MartsData warehouse LifecycleSDLC
![Page 4: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/4.jpg)
2. DATA MODELING
Introduction of Data ModelingEntity Relationship ModelDimensions and Fast TablesLogical ModelingPhysical ModelingSchemas Like Star Schema & Snowflake
SchemasFact less Fact Tables
![Page 5: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/5.jpg)
3. PROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD)
Introduction of Extraction, Transformation and Loading
Types of ETL tools Key tools in the market
![Page 6: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/6.jpg)
4. INSTALLATION PROCESS
• Windows server• Oracle• .NET• Data stage 7.5X2 & 8x
![Page 7: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/7.jpg)
5. DIFFERENCE
Server jobs & Parallel jobs
![Page 8: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/8.jpg)
6. COMPONENTS IN DATASTAGE
Administrator ClintDesigner clientDirector clientImport/export managerMulti client managerConsole for IBM information serverWeb console for IBM information server
![Page 9: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/9.jpg)
7. INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X
Data stage Introduction IBM Information server Architecture IBM Data Quality Architecture Enterprise Information Integration Web Sphere Data Stage Components
![Page 10: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/10.jpg)
8. DATA STAGE DESIGNER
About Web Sphere Data Stage DesignerPartitioning MethodsPartitioning TechniquesDesigner CanvasCentral StorageJob Designing
![Page 11: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/11.jpg)
8. DATA STAGE DESIGNER
Creating the JobsCompiling and Run the JobsExporting and importing the jobsParameter passingSystem(SMP) & Cluster system(MPP)Importing Method(Flat file, Txt, Xls and
Database files)OSH Importing MethodConfiguration file
![Page 12: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/12.jpg)
9. PARALLEL PALETTE
DATABASES STAGES Oracle Database Dynamic RDBMS ODBC SQL Server Teradata FILE STAGES Sequential File Dataset
![Page 13: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/13.jpg)
9. PARALLEL PALETTE
Lookup File set DEV/DEBUG STAGES Peek Head Tail Row Generator Column Generator PROCESSING STAGES Slowly changing dimension stage
![Page 14: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/14.jpg)
9. PARALLEL PALETTE
• Slowly changing dimensions implementation• Aggregator• Copy• Compress• Expand• Filter• Modify• Sort• Switch
![Page 15: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/15.jpg)
9. PARALLEL PALETTE
• Lookup• Join• Marge• Change Capture• Change Apply• Compare• Difference• Funnel• Remove Duplicate• Surrogate Key Generator• Pivot stage• Transformer
![Page 16: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/16.jpg)
10. CONTAINERS
• Shared Containers• Local Containers
![Page 17: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/17.jpg)
11. DS-DIRECTOR
• About DS Director• Validation• Scheduling• Status• View logs• Monitoring• Suppress and Demote the Warnings• Peek view
![Page 18: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/18.jpg)
12. DATASTAGE ADMINISTRATOR
Create ProjectDelete ProjectProtect ProjectEnvironmental variablesAuto purgeRCPOSHCommands ExecuteMultiple InstancesJob Sequence Settings
![Page 19: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/19.jpg)
13. JOB SEQUENCE AREA
Job ActivityJob sequencerStart loop ActivityEnd loop ActivityNotification ActivityTerminator Activity
![Page 20: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/20.jpg)
13. JOB SEQUENCE AREA
• Nested Condition Activity• Exception handling Activity• Execute Command Activity• Wait for file Activity• User variable Activity• Adding Check Points• Restartable
![Page 21: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/21.jpg)
14.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
![Page 22: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/22.jpg)
Contact us for free Demo
We stay with you until you get the results you want. If you really interested, please let me know . We will arrange the Demo Session. Feel Free to call us any time.
Thanks & RegardsSrinivasGloryITTechnologiesEmail:[email protected]:+91-9032813456/+91-9160177789Skype ID : gloryittechnologies
![Page 23: Data stage Online Training](https://reader033.vdocuments.us/reader033/viewer/2022042619/5870f9f21a28ab5f528b5675/html5/thumbnails/23.jpg)
THANK YOU