Course Details: What is Data Warehousing? Difference between OLTP and Data Warehousing Data Acquisition * Data Extraction * Data Transformation * Data Loading Data Marts * Dependent DM * Independent DM Database Design * Star Schema * Fact Constellation Schema SCD (Slowly Changing Dimensions) * TYPE1SCD * TYPE2SCD * TYPE3SCD Basic concepts in SQL. Overview of ETL Tool Architecture Components in ETL Tool *White Box and Block Box testing *functionality in different Transformation rules: * SAMPLE Loading from source target * SORTER Transformation * FILTER Transformation * ROUTER Transformation * EXPRESSION Transformation * JOINER Transformation * UNION Transformation * AGGREGATOR Transformation * RANK Transformation * STORED PROCEEDURE Transformation * SEQUENCE GENERATOR Transformation * Flat File * SQL Transformation Data warehousing Life Cycle Different Types of testing Techniques in ETL * MINUS Query * COUNT Query
RIZE Trainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. RIZE come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.
RIZE trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.
The course begins in a few days, and I still do not have my login information. What do I do? Once your registration for a course is completed, we will send activation link to start your sessions. What happens if I miss my training date, do I have any options? In case you miss training date, we will send recorded sessions to you. Otherwise, we assign for next live batch. How does the online training work? All of our online courses are live instructor led online courses. You will have the ability to interact directly with the trainer. Once registered for a class you will receive detailed instructions on how to access your class. How do I receive the course materials? You receive a link to download the course materials when you register. Our trainers assist you in your assessments, case studies, sample projects, interview skills etc; Will I be able to view the sessions again at a later time? Yes, We provide recorded sessions. Who are your trainers? All our trainers are working professionals from the Industry and have at least 10-12 yrs of relevant experience in various domains. They are subject matter experts. So that participants get a great learning experience. Can I get the same in-class experience at home or work? Yes. You can attend courses anywhere that has an Internet connection. If you choose to participate from your home or workplace, you must validate your own equipment to ensure it meets the required specifications. What should I bring to class? You need to have your course materials, Internet, computer headset and the Link to your Rizetrainings classroom e-mail, which contains the link and LOGIN credentials you need to take your course. Where can I get more information? If you need more information, please call us at +91-970 39 767 53 or send mail to firstname.lastname@example.org . Rize Trainings Advisors will be happy to assist you. Do you offer placements? We help our customers for preparing their resumes, work on sample live projects and provide assistance for interview preparation. We don't offer any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project. What happens if I have technical problems during my class? If you have technical difficulties, you call us at +91-970 39 767 53 . Our support team will resolve any issues you might encounter.