1. Урок 1.00:07:21
    Welcome! Thank you for learning the ETL Testing Course with me!
  2. Урок 2.00:04:52
    What is Data Testing/ETL Testing and the Challenges in ETL testing?
  3. Урок 3.00:07:16
    What will be the future of ETL tools/testing as big data is getting popular?
  4. Урок 4.00:04:22
    Master Data Warehouse Concepts, Step by Step from Scratch
  5. Урок 5.00:04:26
    Is Data Warehouse still relevant in the age of Big Data?
  6. Урок 6.00:03:24
    What is Data?
  7. Урок 7.00:04:53
    Why Data Warehouse is implemented?
  8. Урок 8.00:05:44
    What is a Data Warehouse?
  9. Урок 9.00:01:48
    What is a Data Mart?
  10. Урок 10.00:00:37
    Fundamental difference between Data Warehouse and Data Mart
  11. Урок 11.00:02:41
    Advantages of a Data Mart
  12. Урок 12.00:04:01
    Characteristics of a Data Mart
  13. Урок 13.00:03:14
    Disadvantages of a Data Mart
  14. Урок 14.00:02:16
    Mistakes and Misconceptions of a Data Mart
  15. Урок 15.00:04:09
    Revised: Enterprise Architecture or Centralized Architecture
  16. Урок 16.00:02:50
    Revised: Federated Data Warehouse Architecture
  17. Урок 17.00:03:15
    Multi Tired Architecture
  18. Урок 18.00:03:58
    Components of a Data Warehouse Architecture
  19. Урок 19.00:04:44
    Purpose of a Staging Area in Data Warehouse Architecture - Part 1
  20. Урок 20.00:03:36
    Purpose of a Staging Area in Data Warehouse Architecture - Part 2
  21. Урок 21.00:02:14
    What is Data Modeling?
  22. Урок 22.00:04:04
    Why should a Tester know Data Modeling?
  23. Урок 23.00:03:54
    Data Modeling Techniques
  24. Урок 24.00:03:42
    ER Data Model
  25. Урок 25.00:04:40
    Dimensional Model
  26. Урок 26.00:05:52
    Differences between ER Model and Dimensional Model
  27. Урок 27.00:01:02
    Different phases required to build a Dimensional Data Model
  28. Урок 28.00:02:26
    Business Requirements
  29. Урок 29.00:02:42
    CDM - Conceptual Data Model
  30. Урок 30.00:03:08
    LDM - Logical Data Model
  31. Урок 31.00:01:25
    Physical Data Model
  32. Урок 32.00:04:17
    Database
  33. Урок 33.00:02:49
    What is a Dimension Table?
  34. Урок 34.00:02:06
    What is a Fact Table?
  35. Урок 35.00:01:46
    Additive Facts
  36. Урок 36.00:02:29
    Semi Additive Facts
  37. Урок 37.00:01:31
    Non-Additive Facts
  38. Урок 38.00:02:30
    Fact less Facts
  39. Урок 39.00:05:24
    What is a Star Schema?
  40. Урок 40.00:03:26
    What is a Snow Flake Schema?
  41. Урок 41.00:02:21
    Galaxy Schema or Fact Constellation Schema
  42. Урок 42.00:05:28
    Snow Flake Vs Star Schema
  43. Урок 43.00:06:39
    Conformed Dimensions
  44. Урок 44.00:03:07
    Junk Dimensions
  45. Урок 45.00:03:36
    Degenerate Dimensions
  46. Урок 46.00:02:27
    Role Playing Dimensions
  47. Урок 47.00:05:31
    Slowly Changing Dimensions - Intro and Example Creation
  48. Урок 48.00:12:31
    Slowly Changing Dimensions (SCD) Type 1, 2, 3
  49. Урок 49.00:03:34
    Slowly Changing Dimensions - Summary
  50. Урок 50.00:06:50
    What is Data Integration?
  51. Урок 51.00:04:20
    What is ETL?
  52. Урок 52.00:04:17
    Data Acquisition
  53. Урок 53.00:05:44
    Data Transformation
  54. Урок 54.00:02:50
    Common Questions and Summary
  55. Урок 55.00:06:42
    ETL - Explained
  56. Урок 56.00:05:58
    ELT - Explained
  57. Урок 57.00:02:24
    ETL Vs ELT
  58. Урок 58.00:03:25
    Project Sponsor
  59. Урок 59.00:01:47
    Project Manager
  60. Урок 60.00:02:54
    Functional Analyst or Business Analyst
  61. Урок 61.00:04:18
    SME - Subject Matter Expert
  62. Урок 62.00:03:08
    DW BI Architect and Data Modeler
  63. Урок 63.00:01:22
    DWH Tech Admin
  64. Урок 64.00:01:57
    ETL Developers
  65. Урок 65.00:01:30
    BI OLAP Developers
  66. Урок 66.00:01:59
    ETL Testers / QA Group
  67. Урок 67.00:00:57
    DB UNIX Network Admins
  68. Урок 68.00:09:58
    Data Architect, Data Warehouse Architect, BI Architect and Solution Architect
  69. Урок 69.00:02:18
    Final Note about the Roles
  70. Урок 70.00:01:52
    Different phases in DW/BI/ETL Implementation Approach
  71. Урок 71.00:03:35
    Knowledge Capture Sessions
  72. Урок 72.00:07:22
    Requirements
  73. Урок 73.00:04:49
    Architecture Phase
  74. Урок 74.00:01:36
    Data Model/Database
  75. Урок 75.00:02:44
    ETL Phase
  76. Урок 76.00:02:12
    Data Access Phase
  77. Урок 77.00:01:38
    Data Access Types - Selection
  78. Урок 78.00:00:59
    Data Access Types - Drilling Down
  79. Урок 79.00:00:38
    Data Access Types - Exception Reporting
  80. Урок 80.00:01:28
    Data Access Types - Calculations
  81. Урок 81.00:00:59
    Data Access Types - Graphics and Visualization
  82. Урок 82.00:02:05
    Data Access Types -Data Entry Options
  83. Урок 83.00:01:01
    Data Access Types - Customization
  84. Урок 84.00:00:57
    Data Access Types - WebBased Reporting
  85. Урок 85.00:01:06
    Data Access Types - BroadCasting
  86. Урок 86.00:01:43
    Deploy
  87. Урок 87.00:03:26
    Iterative Approach
  88. Урок 88.00:01:10
    Introduction and Knowledge Capture Sessions
  89. Урок 89.00:02:49
    Test Strategy and Plan
  90. Урок 90.00:02:26
    Define Test Framework
  91. Урок 91.00:04:13
    Assess Source & Target Components
  92. Урок 92.00:03:13
    Test ETL - The Data Centric Method
  93. Урок 93.00:05:35
    System and Integration Testing
  94. Урок 94.00:03:58
    Regression Testing
  95. Урок 95.00:04:34
    Performance Testing
  96. Урок 96.00:03:46
    Acceptance Test
  97. Урок 97.00:04:02
    Different Categories Of DWH Projects
  98. Урок 98.00:02:28
    New DataWarehouse SetUp
  99. Урок 99.00:01:53
    Migration Testing - Includes Data Migration
  100. Урок 100.00:01:29
    Change Requests - For Existing Projects
  101. Урок 101.00:00:55
    OLAP/Dashboard/Report Testing
  102. Урок 102.00:03:51
    Knowledge of the project or the application
  103. Урок 103.00:02:46
    Analysis of the specifications provided by the clients
  104. Урок 104.00:01:19
    Approve requirements and design specifications
  105. Урок 105.00:01:14
    Create and Maintain the test strategy document
  106. Урок 106.00:01:17
    Design the Test Cases as per the Test plan
  107. Урок 107.00:01:24
    Estimate the efforts required to design the test cases and execute the project​
  108. Урок 108.00:01:11
    Tracability of requirements to test cases
  109. Урок 109.00:00:54
    Define Exit and Entrance criteria
  110. Урок 110.00:01:51
    Creating Test Plan, Test Scenario, Test Cases & Test Scripts to validate source
  111. Урок 111.00:04:32
    Test data creation
  112. Урок 112.00:01:21
    Creating and Maintaining Reusable Scripts and Execute Test Scripts
  113. Урок 113.00:01:49
    Execute backend data-driven test cases
  114. Урок 114.00:01:45
    Client Co-ordination and Incorporate UAT Test cases and Identify Bugs
  115. Урок 115.00:03:42
    Other Roles and Responsibilites
  116. Урок 116.00:07:37
    Database Testing Vs GUI Testing
  117. Урок 117.00:16:47
    Structural Database Testing
  118. Урок 118.00:10:52
    Functional Database Testing
  119. Урок 119.00:07:18
    Functional Database Testing - Part 2
  120. Урок 120.00:05:06
    Non Functional Database Testing
  121. Урок 121.00:01:16
    Summary of Database Testing
  122. Урок 122.00:04:52
    What is Data Testing/ETL Testing and the Challenges in ETL testing?
  123. Урок 123.00:07:16
    What will be the future of ETL tools/testing as big data is getting popular?
  124. Урок 124.00:04:22
    Database Testing and ETL Testing
  125. Урок 125.00:01:14
    Differences between Database Testing and ETL Testing
  126. Урок 126.00:04:58
    Database testing during ETL Testing - Explained with a project setup
  127. Урок 127.00:01:42
    Bug Reports
  128. Урок 128.00:02:50
    After Finding the Defect
  129. Урок 129.00:01:26
    Writing the Bug Summary
  130. Урок 130.00:03:02
    Using Appropriate Language/Phrases
  131. Урок 131.00:02:12
    Steps to Reproduce the Defect
  132. Урок 132.00:00:40
    Including Test Data
  133. Урок 133.00:01:35
    Including Screen Shots
  134. Урок 134.00:00:59
    Severity / Priority
  135. Урок 135.00:00:29
    Logs
  136. Урок 136.00:03:10
    Other Information
  137. Урок 137.00:01:00
    Introduction to the common causes for defects
  138. Урок 138.00:03:31
    Insufficient/Incorrect Requirements
  139. Урок 139.00:01:59
    Assumptions/Mis-Understanding
  140. Урок 140.00:02:13
    Wrong Decision During The Design
  141. Урок 141.00:02:12
    Good Programmers With Wrong Goals
  142. Урок 142.00:05:05
    Complexity
  143. Урок 143.00:04:20
    Time Constriants
  144. Урок 144.00:02:14
    Frequently Changing Business Requirements
  145. Урок 145.00:06:52
    Reporting the discrepancy
  146. Урок 146.00:02:36
    Communicating the discrepancy
  147. Урок 147.00:01:34
    Escalating the discrepancy
  148. Урок 148.00:01:47
    Generating Metrics
  149. Урок 149.00:02:45
    Critical Issue Severity
  150. Урок 150.00:01:27
    High Severity Issues
  151. Урок 151.00:00:45
    Medium Severity Issues
  152. Урок 152.00:01:01
    Low Severity Issues
  153. Урок 153.00:08:26
    Defect Status Category Labels
  154. Урок 154.00:04:21
    Metadata Testing
  155. Урок 155.00:05:12
    Data Completeness Testing
  156. Урок 156.00:07:17
    Data Quality Testing - Data Duplicates
  157. Урок 157.00:06:08
    Data Quality Testing - Business Validation and Rules
  158. Урок 158.00:05:55
    Data Transformation - White Box Testing
  159. Урок 159.00:04:01
    Data Transformation - Black Box Testing
  160. Урок 160.00:03:01
    ETL Regression Testing
  161. Урок 161.00:05:42
    Reference Data Testing
  162. Урок 162.00:04:05
    Incremental ETL Testing
  163. Урок 163.00:01:27
    ETL Integration Testing
  164. Урок 164.00:02:44
    ETL Performance Testing
  165. Урок 165.00:04:47
    Different Types of Enterprise Databases
  166. Урок 166.00:06:50
    Different ETL tools available in the Market
  167. Урок 167.00:03:14
    Which ETL tool should you learn, if you are starting with ETL testing now?
  168. Урок 168.00:19:34
    Informatica Power Center Architecture
  169. Урок 169.00:19:04
    Pre Installation Steps & System Pre-Requisites
  170. Урок 170.00:08:03
    Quick Tip: Product Availability Matrix - PAM
  171. Урок 171.00:09:16
    Download Software
  172. Урок 172.00:13:29
    Oracle 11g Installation and SQL Developer Configuration
  173. Урок 173.00:01:46
    Too Many Files!! Which one should I download?
  174. Урок 174.00:03:20
    Extract the Informatica Downloaded files
  175. Урок 175.00:17:01
    Power Center Server Installation
  176. Урок 176.00:02:31
    Power Center Client Installation
  177. Урок 177.00:12:52
    Administration Console Introduction
  178. Урок 178.00:19:19
    List of Services Available
  179. Урок 179.00:18:15
    Repository Service Creation
  180. Урок 180.00:18:03
    Setting up Integration Service
  181. Урок 181.00:13:17
    Repository Configuration and Folder Creation
  182. Урок 182.00:12:22
    Basic File directory structures
  183. Урок 183.00:12:55
    Client Tools and Components
  184. Урок 184.00:04:06
    Setting up the Database Connection at Mapping Designer and Workflow Manager
  185. Урок 185.00:09:43
    Let's start with the Mapping Designer
  186. Урок 186.00:03:03
    Mapping Designer - Finding Object Dependencies
  187. Урок 187.00:12:04
    The Complete Cycle - Lets build the first Mapping, Session and the Workflow
  188. Урок 188.00:19:57
    Transformations Overview
  189. Урок 189.00:00:49
    Different Categories of Transformations
  190. Урок 190.00:02:46
    Active Transformations
  191. Урок 191.00:02:59
    Passive Transformations
  192. Урок 192.00:01:33
    Connected Transformations and Unconnected Transformations
  193. Урок 193.00:01:50
    Multi Group Transformations
  194. Урок 194.00:01:26
    Restricted Process Transformations
  195. Урок 195.00:05:19
    Data Flow Rules
  196. Урок 196.00:01:21
    Brief introduction to Transformations and it's functions
  197. Урок 197.00:02:13
    Aggregator Trasformation
  198. Урок 198.00:01:58
    Expression Transformation
  199. Урок 199.00:01:38
    Filter Transformation
  200. Урок 200.00:02:39
    Joiner Transformation
  201. Урок 201.00:03:21
    Lookup Transformation
  202. Урок 202.00:01:29
    Normalizer Transformation
  203. Урок 203.00:01:09
    Rank Transformation
  204. Урок 204.00:03:33
    Router Transformation
  205. Урок 205.00:02:00
    Sequence Generator Transformation
  206. Урок 206.00:02:49
    Stored Procedure Transformation
  207. Урок 207.00:01:11
    Sorter Transformation
  208. Урок 208.00:02:05
    Source Qualifier Transformation
  209. Урок 209.00:02:03
    Update Strategy Transformation
  210. Урок 210.00:01:13
    XML Source Qualifier Transformation
  211. Урок 211.00:01:25
    XML Parser Transformation
  212. Урок 212.00:01:03
    XML Generator Transformation
  213. Урок 213.00:00:47
    Union Transformation
  214. Урок 214.00:01:01
    HTTP Transformation
  215. Урок 215.00:01:20
    Transaction Control Transformation
  216. Урок 216.00:00:58
    Identity Resolution Transformation
  217. Урок 217.00:00:43
    Custom Transformation
  218. Урок 218.00:00:50
    Data Masking Transformation
  219. Урок 219.00:00:54
    Additional Information about Informatica Power Center Transformations
  220. Урок 220.00:05:07
    Power Center's Native Data Types and Data Type Conversion
  221. Урок 221.00:05:14
    Ports in Informatica
  222. Урок 222.00:03:21
    Different Types of Functions
  223. Урок 223.00:04:30
    Best ways to get around functions
  224. Урок 224.00:08:00
    Components of Workflow Manager
  225. Урок 225.00:11:57
    Workflow Monitor
  226. Урок 226.00:17:30
    Monitor Tool's functionality & Available Options
  227. Урок 227.00:06:57
    Session Log
  228. Урок 228.00:07:26
    Repository Manager Activities
  229. Урок 229.00:17:11
    Mapplet
  230. Урок 230.00:17:30
    Usage of Debugger
  231. Урок 231.00:01:29
    Requirements for Flat File Source to Flat File and Relational Target
  232. Урок 232.00:04:22
    Required Target Attributes based on the requirement
  233. Урок 233.00:01:26
    Target Table creation based on the requirement
  234. Урок 234.00:02:26
    Source Flat File Creation with the test data
  235. Урок 235.00:03:23
    Source File directory for the source to be placed
  236. Урок 236.00:21:40
    Let's create the mapping with the requirements at hand
  237. Урок 237.00:04:36
    Workflow Creation for the mapping created with the requirements
  238. Урок 238.00:06:02
    Different aspects/areas which needs to be verified during a workflow run
  239. Урок 239.00:07:07
    What is S2T document and what should this document contain?
  240. Урок 240.00:05:28
    Source to Target Mapping - Sample 1
  241. Урок 241.00:03:30
    Source to Target Mapping - Sample 2
  242. Урок 242.00:09:07
    Source to Target Mapping - For the requirements we are using
  243. Урок 243.00:12:31
    Technical Test Cases
  244. Урок 244.00:03:56
    Verifying the workflow run and the source to target records
  245. Урок 245.00:11:59
    Test Cases for Business and Data Validations
  246. Урок 246.00:01:48
    Restarting the Workflow for further testing
  247. Урок 247.00:06:19
    Duplicate Records Check and Record Count Verification
  248. Урок 248.00:12:43
    Data Validation Checks - Using SQL queries (Create, Delete, Drop, Select, Minus)
  249. Урок 249.00:05:51
    Test Case for verifying the Unique Sequence numbers
  250. Урок 250.00:03:24
    Fix and Retest of the Active Flag scenario
  251. Урок 251.00:04:47
    Enterprise Architecture or Centralized Architecture
  252. Урок 252.00:03:06
    Federated Architecture
  253. Урок 253.00:12:50
    How do you validate file to table with 1 million records?
  254. Урок 254.00:01:38
    Direct links to other courses