Datastage Online Training Datastage Online Training Course Content Datastage Online Training Introduction to Data Warehousing What is Data Warehousing .Who needs Data Warehousing? Why Data Warehouse is required? Data Warehousing Architecture Types of Systems OLTP OLAP Data Warehousing Life Cycle ODS Data Marts Types of Data Marts Staging Area Data Modelling Concepts Data Modelling Types Source Integration Layer Target Multi-Dimensional Data Modelling Concepts What is dimension data modelling? Difference between ER modelling and dimension modelling What is a Dimension? Different Types of Dimension Confirmed Dimensions Junk Dimensions Degenerate Dimensions Slowly Changing Dimensions Types What is a Fact ? Fact Types ,Classification of Facts? Fact less Fact Table Different Schema Types Star Schema Snow Flake Schema Difference between Star and snow flake schema IBM DataStage Tool: IBM DataStage Contents Introduction about Data Stage DataStage architecture Difference between Server Jobs and Parallel Jobs Difference between Pipeline Parallelism and Partition Parallelism Partition techniques Configuration File Difference between SMP/MPP Architecture Data stage Client Components Data stage Server Components DataStage Administrator Introduction about Administrator Project creation and project properties setup DataStage Designer Introduction about Designer Repository Palette Type of Links File Stages Sequential file Dataset file File set Lookup file set Difference between Sequential file/Dataset/File set Database Stages Dynamic RDBMS Oracle Connector ODBC Enterprise Processing Stages Aggregate Stage Transformer Stage Surrogate Generator Stage Join Stage Merge Stage Lookup Stage Difference between Join/Lookup/Merge Difference between Join/Lookup Remove Duplicates Switch Pivot Modify Funnel Sort 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 Slowly Changing Dimension stage Job Parameters & Parameter set Run time column propagation Sequencer Jobs Debugging Stages Head Tail Peak Row Generator Column Generator Sample Real Time Stages XML Input XML Output XML DataStage Director Introduction to Data stage Director Job Status View View logs Scheduling Note: Training based on real-time standards. New Features : XML stages will be covered as per current job opportunities.