April 20, 2014 \ Ananth TM Datastage Course details – Syllabus INTRODUCTION TO DATAWARE HOUSE (DW) DATA WAREHOUSINGFUNDAMENTALS ✔Introduction of Data warehousing✔purpose of Data warehouse✔DW Architecture✔Data warehouse vs. OLTP Applications✔Data Mart✔Data warehouse Lifecycle DATA MODELING ✔Introduction of Data Modeling✔Entity Relationship(ER) Model✔Fact and Dimension Tables✔Logical Modeling✔Physical Modeling✔Schemas – Star Schema & Snowflake Schemas✔Fact less Fact Tables PROCESS – ETL (EXTRACTION, TRANSACTION & LOAD) ✔Introduction of Extraction , Transformation and Loading (ETL)✔Types of available ETL Tools✔Key tools in the ETL market INSTALLATION PROCESS (Datastage) ✔Windows server✔Oracle✔.NET✔Datastage ✔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 Information server✔Web console for IBM information server INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X ✔Introduction to Datastage✔IBM Information server Architecture✔IBM Data Quality Architecture✔Enterprise Information Integration✔Web Sphere Data stage Components DATASTAGE DESIGNER ✔About Web Sphere Data stage 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✔TeradataFILE 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✔Restartable 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