DATA SATGE TRAINING By SMARTMINDONLINE TRAINING
Data Stage Online Training Course Content • • • • • • • • • • • • • • • •
Data Warehousing Concepts 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 Data Modeling Concepts Source Integration Layer Staging Area Target Analysis & Reporting ODS
Data Stage Online Training Course Content Multi-Dimensional Modeling Concepts • • • • • • • • • • • • • • • •
What is dimension modeling? Difference between ER modeling and dimension modeling What is a Dimension? What is a Fact? Start Schema Snow Flake Schema Difference between Star and snow flake schema Fact Table Different types of facts Dimensional Tables Fact less Fact Table Confirmed Dimensions Junk Dimensions Degenerative Dimensions What are slowly changing Dimensions? Different types of S
Data Stage Online Training Course Content
• • • • • • • • • • • • •
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 components (Server components /Client components) Administrator of Datastage Online Training Introduction about Administrator Project creation and project properties setup
Data Stage Online Training Course Content 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 of Datastage Online Training • Dynamic RDBMS • Oracle Enterprise • 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
• • • • • • • • • • • • • • • •
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 Sequencer Jobs Debugging Stage – Head Tail Peak Row Generator Column Generator Sample
WAY US SMARTMIND ONLINE TRAINING
Smart Mind Online Training following a succeeding career in IT sector. Smart Mind Online is a global leading IT Training provider. We specialized in providing Online Training services on hadoop, java, oracle and sap all modules. We teach students and train them for IT profession. Also, we will provide job support by IT professionals for job. Smart Mind Online Training offers Virtual room coaching as a accomplished and efficient to site-based and sophistication Online Training. Virtual class room could be a web-based setting that enables you to participate in live coaching events while not the necessity to travel. Our Passion is to teach every student in real time. Smart Mind Online Training is an IT Solutions company specializing in custom software development, IT Training and development courses. Smart Mind Online Training provides best Training including web application development, and software development Training. We work to conceptualize and realize, Sap application development. Our Online web services include custom development, We offer Corporate and Individual Trainings on the following skills like Hadoop tutorial, Java, Oracle, Dotnet, Data warehouse, Sap Modules, etc.
About us: Smart Mind Online Training is one altogether the leading IT work Institutions, established in Hyderabad with the target of providing Training services for various requirements in IT business. We deliver company Trainings as per the scholar requirements colonize and ground breaker of worldwide e Learning solutions and providing technology enabled Online Training for individuals and company educators. We have extraordinarily talented faculty in their individual courses. we have a tendency to tend to furnish with Online work given North Yankee country a grip on varied Technologies. Our team trainer’s expertise in every part of the e Learning modules. Our Company was organized from several years successfully by team contains of huge professionals, each with minimum six years of group action experience, created good business info and flat soft skills. They are for Our Company with their business info, understanding of student’s requirements and key approaches. Our Company is lucky enough to possess been associated with skilled and experienced faculty among the fields of code.
INDIA: +91 9949599844 USA: +1-347-606-2716 contact@smartmindonlinetraining.com