-
Урок 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