Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай ETL testing: From beginner to expert, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:07:21
    Welcome! Thank you for learning the ETL Testing Course with me!
  • Урок 2. 00:04:52
    What is Data Testing/ETL Testing and the Challenges in ETL testing?
  • Урок 3. 00:07:16
    What will be the future of ETL tools/testing as big data is getting popular?
  • Урок 4. 00:04:22
    Master Data Warehouse Concepts, Step by Step from Scratch
  • Урок 5. 00:04:26
    Is Data Warehouse still relevant in the age of Big Data?
  • Урок 6. 00:03:24
    What is Data?
  • Урок 7. 00:04:53
    Why Data Warehouse is implemented?
  • Урок 8. 00:05:44
    What is a Data Warehouse?
  • Урок 9. 00:01:48
    What is a Data Mart?
  • Урок 10. 00:00:37
    Fundamental difference between Data Warehouse and Data Mart
  • Урок 11. 00:02:41
    Advantages of a Data Mart
  • Урок 12. 00:04:01
    Characteristics of a Data Mart
  • Урок 13. 00:03:14
    Disadvantages of a Data Mart
  • Урок 14. 00:02:16
    Mistakes and Misconceptions of a Data Mart
  • Урок 15. 00:04:09
    Revised: Enterprise Architecture or Centralized Architecture
  • Урок 16. 00:02:50
    Revised: Federated Data Warehouse Architecture
  • Урок 17. 00:03:15
    Multi Tired Architecture
  • Урок 18. 00:03:58
    Components of a Data Warehouse Architecture
  • Урок 19. 00:04:44
    Purpose of a Staging Area in Data Warehouse Architecture - Part 1
  • Урок 20. 00:03:36
    Purpose of a Staging Area in Data Warehouse Architecture - Part 2
  • Урок 21. 00:02:14
    What is Data Modeling?
  • Урок 22. 00:04:04
    Why should a Tester know Data Modeling?
  • Урок 23. 00:03:54
    Data Modeling Techniques
  • Урок 24. 00:03:42
    ER Data Model
  • Урок 25. 00:04:40
    Dimensional Model
  • Урок 26. 00:05:52
    Differences between ER Model and Dimensional Model
  • Урок 27. 00:01:02
    Different phases required to build a Dimensional Data Model
  • Урок 28. 00:02:26
    Business Requirements
  • Урок 29. 00:02:42
    CDM - Conceptual Data Model
  • Урок 30. 00:03:08
    LDM - Logical Data Model
  • Урок 31. 00:01:25
    Physical Data Model
  • Урок 32. 00:04:17
    Database
  • Урок 33. 00:02:49
    What is a Dimension Table?
  • Урок 34. 00:02:06
    What is a Fact Table?
  • Урок 35. 00:01:46
    Additive Facts
  • Урок 36. 00:02:29
    Semi Additive Facts
  • Урок 37. 00:01:31
    Non-Additive Facts
  • Урок 38. 00:02:30
    Fact less Facts
  • Урок 39. 00:05:24
    What is a Star Schema?
  • Урок 40. 00:03:26
    What is a Snow Flake Schema?
  • Урок 41. 00:02:21
    Galaxy Schema or Fact Constellation Schema
  • Урок 42. 00:05:28
    Snow Flake Vs Star Schema
  • Урок 43. 00:06:39
    Conformed Dimensions
  • Урок 44. 00:03:07
    Junk Dimensions
  • Урок 45. 00:03:36
    Degenerate Dimensions
  • Урок 46. 00:02:27
    Role Playing Dimensions
  • Урок 47. 00:05:31
    Slowly Changing Dimensions - Intro and Example Creation
  • Урок 48. 00:12:31
    Slowly Changing Dimensions (SCD) Type 1, 2, 3
  • Урок 49. 00:03:34
    Slowly Changing Dimensions - Summary
  • Урок 50. 00:06:50
    What is Data Integration?
  • Урок 51. 00:04:20
    What is ETL?
  • Урок 52. 00:04:17
    Data Acquisition
  • Урок 53. 00:05:44
    Data Transformation
  • Урок 54. 00:02:50
    Common Questions and Summary
  • Урок 55. 00:06:42
    ETL - Explained
  • Урок 56. 00:05:58
    ELT - Explained
  • Урок 57. 00:02:24
    ETL Vs ELT
  • Урок 58. 00:03:25
    Project Sponsor
  • Урок 59. 00:01:47
    Project Manager
  • Урок 60. 00:02:54
    Functional Analyst or Business Analyst
  • Урок 61. 00:04:18
    SME - Subject Matter Expert
  • Урок 62. 00:03:08
    DW BI Architect and Data Modeler
  • Урок 63. 00:01:22
    DWH Tech Admin
  • Урок 64. 00:01:57
    ETL Developers
  • Урок 65. 00:01:30
    BI OLAP Developers
  • Урок 66. 00:01:59
    ETL Testers / QA Group
  • Урок 67. 00:00:57
    DB UNIX Network Admins
  • Урок 68. 00:09:58
    Data Architect, Data Warehouse Architect, BI Architect and Solution Architect
  • Урок 69. 00:02:18
    Final Note about the Roles
  • Урок 70. 00:01:52
    Different phases in DW/BI/ETL Implementation Approach
  • Урок 71. 00:03:35
    Knowledge Capture Sessions
  • Урок 72. 00:07:22
    Requirements
  • Урок 73. 00:04:49
    Architecture Phase
  • Урок 74. 00:01:36
    Data Model/Database
  • Урок 75. 00:02:44
    ETL Phase
  • Урок 76. 00:02:12
    Data Access Phase
  • Урок 77. 00:01:38
    Data Access Types - Selection
  • Урок 78. 00:00:59
    Data Access Types - Drilling Down
  • Урок 79. 00:00:38
    Data Access Types - Exception Reporting
  • Урок 80. 00:01:28
    Data Access Types - Calculations
  • Урок 81. 00:00:59
    Data Access Types - Graphics and Visualization
  • Урок 82. 00:02:05
    Data Access Types -Data Entry Options
  • Урок 83. 00:01:01
    Data Access Types - Customization
  • Урок 84. 00:00:57
    Data Access Types - WebBased Reporting
  • Урок 85. 00:01:06
    Data Access Types - BroadCasting
  • Урок 86. 00:01:43
    Deploy
  • Урок 87. 00:03:26
    Iterative Approach
  • Урок 88. 00:01:10
    Introduction and Knowledge Capture Sessions
  • Урок 89. 00:02:49
    Test Strategy and Plan
  • Урок 90. 00:02:26
    Define Test Framework
  • Урок 91. 00:04:13
    Assess Source & Target Components
  • Урок 92. 00:03:13
    Test ETL - The Data Centric Method
  • Урок 93. 00:05:35
    System and Integration Testing
  • Урок 94. 00:03:58
    Regression Testing
  • Урок 95. 00:04:34
    Performance Testing
  • Урок 96. 00:03:46
    Acceptance Test
  • Урок 97. 00:04:02
    Different Categories Of DWH Projects
  • Урок 98. 00:02:28
    New DataWarehouse SetUp
  • Урок 99. 00:01:53
    Migration Testing - Includes Data Migration
  • Урок 100. 00:01:29
    Change Requests - For Existing Projects
  • Урок 101. 00:00:55
    OLAP/Dashboard/Report Testing
  • Урок 102. 00:03:51
    Knowledge of the project or the application
  • Урок 103. 00:02:46
    Analysis of the specifications provided by the clients
  • Урок 104. 00:01:19
    Approve requirements and design specifications
  • Урок 105. 00:01:14
    Create and Maintain the test strategy document
  • Урок 106. 00:01:17
    Design the Test Cases as per the Test plan
  • Урок 107. 00:01:24
    Estimate the efforts required to design the test cases and execute the project​
  • Урок 108. 00:01:11
    Tracability of requirements to test cases
  • Урок 109. 00:00:54
    Define Exit and Entrance criteria
  • Урок 110. 00:01:51
    Creating Test Plan, Test Scenario, Test Cases & Test Scripts to validate source
  • Урок 111. 00:04:32
    Test data creation
  • Урок 112. 00:01:21
    Creating and Maintaining Reusable Scripts and Execute Test Scripts
  • Урок 113. 00:01:49
    Execute backend data-driven test cases
  • Урок 114. 00:01:45
    Client Co-ordination and Incorporate UAT Test cases and Identify Bugs
  • Урок 115. 00:03:42
    Other Roles and Responsibilites
  • Урок 116. 00:07:37
    Database Testing Vs GUI Testing
  • Урок 117. 00:16:47
    Structural Database Testing
  • Урок 118. 00:10:52
    Functional Database Testing
  • Урок 119. 00:07:18
    Functional Database Testing - Part 2
  • Урок 120. 00:05:06
    Non Functional Database Testing
  • Урок 121. 00:01:16
    Summary of Database Testing
  • Урок 122. 00:04:52
    What is Data Testing/ETL Testing and the Challenges in ETL testing?
  • Урок 123. 00:07:16
    What will be the future of ETL tools/testing as big data is getting popular?
  • Урок 124. 00:04:22
    Database Testing and ETL Testing
  • Урок 125. 00:01:14
    Differences between Database Testing and ETL Testing
  • Урок 126. 00:04:58
    Database testing during ETL Testing - Explained with a project setup
  • Урок 127. 00:01:42
    Bug Reports
  • Урок 128. 00:02:50
    After Finding the Defect
  • Урок 129. 00:01:26
    Writing the Bug Summary
  • Урок 130. 00:03:02
    Using Appropriate Language/Phrases
  • Урок 131. 00:02:12
    Steps to Reproduce the Defect
  • Урок 132. 00:00:40
    Including Test Data
  • Урок 133. 00:01:35
    Including Screen Shots
  • Урок 134. 00:00:59
    Severity / Priority
  • Урок 135. 00:00:29
    Logs
  • Урок 136. 00:03:10
    Other Information
  • Урок 137. 00:01:00
    Introduction to the common causes for defects
  • Урок 138. 00:03:31
    Insufficient/Incorrect Requirements
  • Урок 139. 00:01:59
    Assumptions/Mis-Understanding
  • Урок 140. 00:02:13
    Wrong Decision During The Design
  • Урок 141. 00:02:12
    Good Programmers With Wrong Goals
  • Урок 142. 00:05:05
    Complexity
  • Урок 143. 00:04:20
    Time Constriants
  • Урок 144. 00:02:14
    Frequently Changing Business Requirements
  • Урок 145. 00:06:52
    Reporting the discrepancy
  • Урок 146. 00:02:36
    Communicating the discrepancy
  • Урок 147. 00:01:34
    Escalating the discrepancy
  • Урок 148. 00:01:47
    Generating Metrics
  • Урок 149. 00:02:45
    Critical Issue Severity
  • Урок 150. 00:01:27
    High Severity Issues
  • Урок 151. 00:00:45
    Medium Severity Issues
  • Урок 152. 00:01:01
    Low Severity Issues
  • Урок 153. 00:08:26
    Defect Status Category Labels
  • Урок 154. 00:04:21
    Metadata Testing
  • Урок 155. 00:05:12
    Data Completeness Testing
  • Урок 156. 00:07:17
    Data Quality Testing - Data Duplicates
  • Урок 157. 00:06:08
    Data Quality Testing - Business Validation and Rules
  • Урок 158. 00:05:55
    Data Transformation - White Box Testing
  • Урок 159. 00:04:01
    Data Transformation - Black Box Testing
  • Урок 160. 00:03:01
    ETL Regression Testing
  • Урок 161. 00:05:42
    Reference Data Testing
  • Урок 162. 00:04:05
    Incremental ETL Testing
  • Урок 163. 00:01:27
    ETL Integration Testing
  • Урок 164. 00:02:44
    ETL Performance Testing
  • Урок 165. 00:04:47
    Different Types of Enterprise Databases
  • Урок 166. 00:06:50
    Different ETL tools available in the Market
  • Урок 167. 00:03:14
    Which ETL tool should you learn, if you are starting with ETL testing now?
  • Урок 168. 00:19:34
    Informatica Power Center Architecture
  • Урок 169. 00:19:04
    Pre Installation Steps & System Pre-Requisites
  • Урок 170. 00:08:03
    Quick Tip: Product Availability Matrix - PAM
  • Урок 171. 00:09:16
    Download Software
  • Урок 172. 00:13:29
    Oracle 11g Installation and SQL Developer Configuration
  • Урок 173. 00:01:46
    Too Many Files!! Which one should I download?
  • Урок 174. 00:03:20
    Extract the Informatica Downloaded files
  • Урок 175. 00:17:01
    Power Center Server Installation
  • Урок 176. 00:02:31
    Power Center Client Installation
  • Урок 177. 00:12:52
    Administration Console Introduction
  • Урок 178. 00:19:19
    List of Services Available
  • Урок 179. 00:18:15
    Repository Service Creation
  • Урок 180. 00:18:03
    Setting up Integration Service
  • Урок 181. 00:13:17
    Repository Configuration and Folder Creation
  • Урок 182. 00:12:22
    Basic File directory structures
  • Урок 183. 00:12:55
    Client Tools and Components
  • Урок 184. 00:04:06
    Setting up the Database Connection at Mapping Designer and Workflow Manager
  • Урок 185. 00:09:43
    Let's start with the Mapping Designer
  • Урок 186. 00:03:03
    Mapping Designer - Finding Object Dependencies
  • Урок 187. 00:12:04
    The Complete Cycle - Lets build the first Mapping, Session and the Workflow
  • Урок 188. 00:19:57
    Transformations Overview
  • Урок 189. 00:00:49
    Different Categories of Transformations
  • Урок 190. 00:02:46
    Active Transformations
  • Урок 191. 00:02:59
    Passive Transformations
  • Урок 192. 00:01:33
    Connected Transformations and Unconnected Transformations
  • Урок 193. 00:01:50
    Multi Group Transformations
  • Урок 194. 00:01:26
    Restricted Process Transformations
  • Урок 195. 00:05:19
    Data Flow Rules
  • Урок 196. 00:01:21
    Brief introduction to Transformations and it's functions
  • Урок 197. 00:02:13
    Aggregator Trasformation
  • Урок 198. 00:01:58
    Expression Transformation
  • Урок 199. 00:01:38
    Filter Transformation
  • Урок 200. 00:02:39
    Joiner Transformation
  • Урок 201. 00:03:21
    Lookup Transformation
  • Урок 202. 00:01:29
    Normalizer Transformation
  • Урок 203. 00:01:09
    Rank Transformation
  • Урок 204. 00:03:33
    Router Transformation
  • Урок 205. 00:02:00
    Sequence Generator Transformation
  • Урок 206. 00:02:49
    Stored Procedure Transformation
  • Урок 207. 00:01:11
    Sorter Transformation
  • Урок 208. 00:02:05
    Source Qualifier Transformation
  • Урок 209. 00:02:03
    Update Strategy Transformation
  • Урок 210. 00:01:13
    XML Source Qualifier Transformation
  • Урок 211. 00:01:25
    XML Parser Transformation
  • Урок 212. 00:01:03
    XML Generator Transformation
  • Урок 213. 00:00:47
    Union Transformation
  • Урок 214. 00:01:01
    HTTP Transformation
  • Урок 215. 00:01:20
    Transaction Control Transformation
  • Урок 216. 00:00:58
    Identity Resolution Transformation
  • Урок 217. 00:00:43
    Custom Transformation
  • Урок 218. 00:00:50
    Data Masking Transformation
  • Урок 219. 00:00:54
    Additional Information about Informatica Power Center Transformations
  • Урок 220. 00:05:07
    Power Center's Native Data Types and Data Type Conversion
  • Урок 221. 00:05:14
    Ports in Informatica
  • Урок 222. 00:03:21
    Different Types of Functions
  • Урок 223. 00:04:30
    Best ways to get around functions
  • Урок 224. 00:08:00
    Components of Workflow Manager
  • Урок 225. 00:11:57
    Workflow Monitor
  • Урок 226. 00:17:30
    Monitor Tool's functionality & Available Options
  • Урок 227. 00:06:57
    Session Log
  • Урок 228. 00:07:26
    Repository Manager Activities
  • Урок 229. 00:17:11
    Mapplet
  • Урок 230. 00:17:30
    Usage of Debugger
  • Урок 231. 00:01:29
    Requirements for Flat File Source to Flat File and Relational Target
  • Урок 232. 00:04:22
    Required Target Attributes based on the requirement
  • Урок 233. 00:01:26
    Target Table creation based on the requirement
  • Урок 234. 00:02:26
    Source Flat File Creation with the test data
  • Урок 235. 00:03:23
    Source File directory for the source to be placed
  • Урок 236. 00:21:40
    Let's create the mapping with the requirements at hand
  • Урок 237. 00:04:36
    Workflow Creation for the mapping created with the requirements
  • Урок 238. 00:06:02
    Different aspects/areas which needs to be verified during a workflow run
  • Урок 239. 00:07:07
    What is S2T document and what should this document contain?
  • Урок 240. 00:05:28
    Source to Target Mapping - Sample 1
  • Урок 241. 00:03:30
    Source to Target Mapping - Sample 2
  • Урок 242. 00:09:07
    Source to Target Mapping - For the requirements we are using
  • Урок 243. 00:12:31
    Technical Test Cases
  • Урок 244. 00:03:56
    Verifying the workflow run and the source to target records
  • Урок 245. 00:11:59
    Test Cases for Business and Data Validations
  • Урок 246. 00:01:48
    Restarting the Workflow for further testing
  • Урок 247. 00:06:19
    Duplicate Records Check and Record Count Verification
  • Урок 248. 00:12:43
    Data Validation Checks - Using SQL queries (Create, Delete, Drop, Select, Minus)
  • Урок 249. 00:05:51
    Test Case for verifying the Unique Sequence numbers
  • Урок 250. 00:03:24
    Fix and Retest of the Active Flag scenario
  • Урок 251. 00:04:47
    Enterprise Architecture or Centralized Architecture
  • Урок 252. 00:03:06
    Federated Architecture
  • Урок 253. 00:12:50
    How do you validate file to table with 1 million records?
  • Урок 254. 00:01:38
    Direct links to other courses