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