1 / 11

data stage Online Training Institute in India,USA,UK,Canada.

DataStage is an ETL tool of the IBM Information Platforms Choices program as well as IBM InfoSphere and part. It works on the graphical notation to construct data integration choices and may be had in a number of forms including the Enterprise Edition, the Server Edition, in addition to the MVS Version.we're supplying DataStage Online Training in India,USA,UK,Canada.<br>http://smartmindonlinetraining.com/datastage-online-training/

SummaMcclane
Download Presentation

data stage Online Training Institute in India,USA,UK,Canada.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATA SATGE TRAINING By HYDERABADSYS ONLINE TRAINING

  2. Data Stage Online Training Course Content • Datastage Online Training Course Content: 1.Introduction of Data warehousing2.purpose of Data warehouse3.DW Architecture4.Data warehouse vs. OLTP Applications5.Data Mart6.Data warehouse Lifecycle

  3. DATA MODELING 1.Introduction of Data Modeling2.Entity Relationship(ER) Model3.Fact and Dimension Tables4.Logical Modeling5.Physical Modeling6.Schemas – Star Schema & Snowflake Schemas7.Fact less Fact Tables

  4. Data Stage Online Training Course Content • PROCESS – ETL (EXTRACTION, TRANSACTION & LOAD) 1.Introduction of Extraction , Transformation and Loading (ETL)2.Types of available ETL Tools3.Key tools in the ETL market • INSTALLATION PROCESS (Datastage) 1.Windows server2.Oracle3..NET4.Datastage 7.5X2 & 8x

  5. DIFFERENCE 1.Server jobs & Parallel jobs • COMPONENTS IN DATASTAGE 1.Administrator client2.Designer client3.Director client4.Import/export manager5.Multi client manager

  6. Data Stage Online Training Course Content • INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X 1.Introduction to Datastage2.IBM Information server Architecture3.IBM Data Quality Architecture4.Enterprise Information Integration5.Web Sphere Data stage Components

  7. Data Stage Online Training Course Content • DATASTAGE DESIGNER 1.About Web Sphere Data stage Designer2.Partitioning Methods3.Partitioning Techniques4.Designer Canvas5.Central Storage6.Job Designing7.Creating the Jobs8.Compiling and Run the Jobs9.Exporting and importing the jobs10.Parameter passing11.System(SMP) & Cluster system(MPP)12.Importing Metho

  8. Different types of sorting and sort stage. • Different types of combining and collecting techniques. • Filter • External filter • Difference between filter, External filter and switch stages. • Change Capture stage • Job Parameters & Parameter set • Run time column propagation

  9. Sequencer Jobs • Debugging Stage –  • Head • Tail • Peak • Row Generator • Column Generator • Sample

More Related