06 Dimensional Modeling/023 Differences between ER Model and Dimensional Model.mp4 15.7 MB
06 Dimensional Modeling/attached_files/023 Differences between ER Model and Dimensional Model/differences-between-er-modeling-and-dimensional-modeling.pdf 616.6 kB
07 How to build a Dimensional Model/024 Different phases required to build a Dimensional Data Model.mp4 2.0 MB
07 How to build a Dimensional Model/025 Business Requirements.mp4 5.4 MB
07 How to build a Dimensional Model/026 CDM - Conceptual Data Model.mp4 5.1 MB
07 How to build a Dimensional Model/027 LDM - Logical Data Model.mp4 6.3 MB
07 How to build a Dimensional Model/028 Physical Data Model.mp4 2.7 MB
07 How to build a Dimensional Model/029 Database.mp4 7.8 MB
07 How to build a Dimensional Model/quizzes/004 Test your understanding.html 3.0 kB
08 Various Objects in a Dimensional Model/030 What is a Dimension Table.mp4 5.4 MB
08 Various Objects in a Dimensional Model/031 What is a Fact Table.mp4 4.0 MB
08 Various Objects in a Dimensional Model/032 Additive Facts.mp4 3.7 MB
08 Various Objects in a Dimensional Model/033 Semi Additive Facts.mp4 5.0 MB
08 Various Objects in a Dimensional Model/034 Non-Additive Facts.mp4 2.8 MB
08 Various Objects in a Dimensional Model/035 Fact less Facts.mp4 4.9 MB
08 Various Objects in a Dimensional Model/036 What is a Star Schema.mp4 10.7 MB
08 Various Objects in a Dimensional Model/037 What is a Snow Flake Schema.mp4 7.0 MB
08 Various Objects in a Dimensional Model/038 Galaxy Schema or Fact Constellation Schema.mp4 4.7 MB
08 Various Objects in a Dimensional Model/039 Snow Flake Vs Star Schema.mp4 12.6 MB
08 Various Objects in a Dimensional Model/040 Conformed Dimensions.mp4 12.3 MB
08 Various Objects in a Dimensional Model/041 Junk Dimensions.mp4 5.5 MB
08 Various Objects in a Dimensional Model/042 Degenerate Dimensions.mp4 7.4 MB
08 Various Objects in a Dimensional Model/043 Role Playing Dimensions.mp4 4.3 MB
08 Various Objects in a Dimensional Model/044 Slowly Changing Dimensions - Intro and Example Creation.mp4 11.4 MB
08 Various Objects in a Dimensional Model/045 Slowly Changing Dimensions SCD Type 1 2 3.mp4 40.4 MB
08 Various Objects in a Dimensional Model/046 Slowly Changing Dimensions - Summary.mp4 9.2 MB
08 Various Objects in a Dimensional Model/quizzes/005 Test your understanding on Dimensional Model Objects.html 4.0 kB
09 Data Integration and ETL/047 What is Data Integration.mp4 21.5 MB
09 Data Integration and ETL/048 What is ETL.mp4 9.4 MB
09 Data Integration and ETL/049 Data Acquisition.mp4 9.4 MB
09 Data Integration and ETL/050 Data Transformation.mp4 13.3 MB
09 Data Integration and ETL/051 Common Questions and Summary.mp4 6.4 MB
09 Data Integration and ETL/quizzes/006 Test your understanding on Data Integration and ETL.html 3.5 kB
10 ETL Vs ELT/052 ETL - Explained.mp4 16.7 MB
10 ETL Vs ELT/053 ELT - Explained.mp4 13.8 MB
10 ETL Vs ELT/054 ETL Vs ELT.mp4 4.8 MB
11 Typical Roles In DWH Project/055 Project Sponsor.mp4 10.5 MB
11 Typical Roles In DWH Project/056 Project Manager.mp4 3.5 MB
11 Typical Roles In DWH Project/057 Functional Analyst or Business Analyst.mp4 5.7 MB
11 Typical Roles In DWH Project/058 SME - Subject Matter Expert.mp4 20.3 MB
11 Typical Roles In DWH Project/059 DW BI Architect and Data Modeler.mp4 6.9 MB
12 DWBIETL Implementation Approach/quizzes/008 Test your understanding on the DWBI Implementation Approach.html 2.1 kB
13 DWBIETL Test Stratergy and Data Centric Approach/085 Introduction and Knowledge Capture Sessions.mp4 2.3 MB
13 DWBIETL Test Stratergy and Data Centric Approach/086 Test Strategy and Plan.mp4 7.4 MB
13 DWBIETL Test Stratergy and Data Centric Approach/087 Define Test Framework.mp4 5.3 MB
13 DWBIETL Test Stratergy and Data Centric Approach/088 Assess Source Target Components.mp4 9.4 MB
13 DWBIETL Test Stratergy and Data Centric Approach/089 Test ETL - The Data Centric Method.mp4 7.0 MB
13 DWBIETL Test Stratergy and Data Centric Approach/090 System and Integration Testing.mp4 12.2 MB
13 DWBIETL Test Stratergy and Data Centric Approach/091 Regression Testing.mp4 8.7 MB
13 DWBIETL Test Stratergy and Data Centric Approach/092 Performance Testing.mp4 9.6 MB
13 DWBIETL Test Stratergy and Data Centric Approach/093 Acceptance Test.mp4 8.1 MB
14 Different Categories Of Projects where DWBIETL Testing is required/094 Different Categories Of DWH Projects.mp4 9.8 MB
14 Different Categories Of Projects where DWBIETL Testing is required/095 New DataWarehouse SetUp.mp4 6.7 MB
14 Different Categories Of Projects where DWBIETL Testing is required/096 Migration Testing - Includes Data Migration.mp4 4.3 MB
14 Different Categories Of Projects where DWBIETL Testing is required/097 Change Requests - For Existing Projects.mp4 3.8 MB
14 Different Categories Of Projects where DWBIETL Testing is required/098 OLAPDashboardReport Testing.mp4 2.1 MB
14 Different Categories Of Projects where DWBIETL Testing is required/quizzes/009 Test your understanding on different phases of the DWBI projects.html 2.4 kB
15 Roles and Responsibilities of an ETL Testing Professional/099 Knowledge of the project or the application.mp4 8.9 MB
15 Roles and Responsibilities of an ETL Testing Professional/100 Analysis of the specifications provided by the clients.mp4 6.3 MB
15 Roles and Responsibilities of an ETL Testing Professional/101 Approve requirements and design specifications.mp4 3.0 MB
15 Roles and Responsibilities of an ETL Testing Professional/102 Create and Maintain the test strategy document.mp4 3.6 MB
15 Roles and Responsibilities of an ETL Testing Professional/103 Design the Test Cases as per the Test plan.mp4 4.1 MB
15 Roles and Responsibilities of an ETL Testing Professional/104 Estimate the efforts required to design the test cases and execute the project.mp4 2.8 MB
15 Roles and Responsibilities of an ETL Testing Professional/105 Tracability of requirements to test cases.mp4 2.4 MB
15 Roles and Responsibilities of an ETL Testing Professional/106 Define Exit and Entrance criteria.mp4 2.8 MB
15 Roles and Responsibilities of an ETL Testing Professional/107 Creating Test Plan Test Scenario Test Cases Test Scripts to validate source.mp4 4.3 MB
15 Roles and Responsibilities of an ETL Testing Professional/108 Test data creation.mp4 10.5 MB
15 Roles and Responsibilities of an ETL Testing Professional/109 Creating and Maintaining Reusable Scripts and Execute Test Scripts.mp4 3.3 MB
15 Roles and Responsibilities of an ETL Testing Professional/110 Execute backend data-driven test cases.mp4 4.2 MB
15 Roles and Responsibilities of an ETL Testing Professional/111 Client Co-ordination and Incorporate UAT Test cases and Identify Bugs.mp4 4.5 MB
15 Roles and Responsibilities of an ETL Testing Professional/112 Other Roles and Responsibilites.mp4 8.4 MB
15 Roles and Responsibilities of an ETL Testing Professional/113 INFOGRAPHIC The Roles Responsibilities of an ETL Tester ETL QA Analyst.html 3.2 kB
15 Roles and Responsibilities of an ETL Testing Professional/quizzes/010 Test your understanding on Roles and Responsibilities of QA Testers.html 2.4 kB
16 Database Testing/114 Database Testing Vs GUI Testing.mp4 19.2 MB
36 Informatica PowerCenter Monitor/quizzes/014 Test your understanding on Monitor and Session Logs.html 2.1 kB
37 Other important objects and activities in Informatica/223 Repository Manager Activities.mp4 19.8 MB
37 Other important objects and activities in Informatica/224 Mapplet.mp4 47.0 MB
37 Other important objects and activities in Informatica/225 Usage of Debugger.mp4 54.4 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/226 Requirements for Flat File Source to Flat File and Relational Target.mp4 5.3 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/227 Required Target Attributes based on the requirement.mp4 11.6 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/228 Target Table creation based on the requirement.mp4 4.9 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/229 Source Flat File Creation with the test data.mp4 6.6 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/230 Source File directory for the source to be placed.mp4 9.5 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/231 Lets create the mapping with the requirements at hand.mp4 72.0 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/232 Workflow Creation for the mapping created with the requirements.mp4 12.5 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/233 Different aspectsareas which needs to be verified during a workflow run.mp4 16.5 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/234 What is S2T document and what should this document contain.mp4 14.4 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/235 Source to Target Mapping - Sample 1.mp4 14.5 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/236 Source to Target Mapping - Sample 2.mp4 13.1 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/237 Source to Target Mapping - For the requirements we are using.mp4 39.5 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/238 Technical Test Cases.mp4 40.7 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/239 Verifying the workflow run and the source to target records.mp4 12.4 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/240 Test Cases for Business and Data Validations.mp4 46.7 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/241 Bug fixes for the issues identified.mp4 40.7 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/242 Restarting the Workflow for further testing.mp4 7.2 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/243 Duplicate Records Check and Record Count Verification.mp4 21.8 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/244 Data Validation Checks - Using SQL queries Create Delete Drop Select Minus.mp4 44.8 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/245 Test Case for verifying the Unique Sequence numbers.mp4 21.4 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/246 Fix and Retest of the Active Flag scenario.mp4 11.7 MB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/attached_files/226 Requirements for Flat File Source to Flat File and Relational Target/Practical-Example-1.pdf 467.5 kB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/attached_files/235 Source to Target Mapping - Sample 1/sample.xlsx 10.7 kB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/attached_files/236 Source to Target Mapping - Sample 2/S2T.xlsx 23.2 kB
38 Practical Scenario Flat File Source to Flat File and Relational Targets/attached_files/240 Test Cases for Business and Data Validations/TestCaseExecution.xlsx 19.9 kB
39 Retired Lectures/247 Enterprise Architecture or Centralized Architecture.mp4 9.3 MB