FreeTutorials Us the complete etl testing course | 7C76FFC902EDBA84D769E45B361F7FCD0A192A0C

FreeTutorials Us the complete etl testing course

Name	[FreeTutorials.Us] the-complete-etl-testing-course	DOWNLOAD Copy Link
Total Size	2.8 GB
Total Files	271
Hash	7C76FFC902EDBA84D769E45B361F7FCD0A192A0C

/01 Welcome Thank you for learning the ETL Testing Course with me/
001 Welcome Thank you for learning the ETL Testing Course with me.mp4	26.8 MB
/02 Before we start/
002 What is Data TestingETL Testing and the Challenges in ETL testing.mp4	12.7 MB
003 What will be the future of ETL toolstesting as big data is getting popular.mp4	27.4 MB
/03 The Basics - Data warehouse Concepts course/
004 Master Data Warehouse Concepts Step by Step from Scratch.mp4	18.7 MB
005 Is Data Warehouse still relevant in the age of Big Data.mp4	15.8 MB
006 What is Data.mp4	5.7 MB
007 Why Data Warehouse is implemented.mp4	8.5 MB
008 What is a Data Warehouse.mp4	17.0 MB
/quizzes/
001 Test your understanding on the Data Warehouse basics.html	4.1 KB
/04 Data Mart/
009 What is a Data Mart.mp4	4.2 MB
010 Fundamental difference between Data Warehouse and Data Mart.mp4	1.3 MB
011 Mistakes and Misconceptions of a Data Mart.mp4	6.7 MB
/quizzes/
002 Test your understanding on the Data Mart Concepts.html	3.5 KB
/05 Data Warehouse Architectures/
012 Revised Enterprise Architecture or Centralized Architecture.mp4	8.0 MB
013 Revised Federated Data Warehouse Architecture.mp4	5.9 MB
014 Multi Tired Architecture.mp4	7.2 MB
015 Components of a Data Warehouse Architecture.mp4	8.1 MB
016 Purpose of a Staging Area in Data Warehouse Architecture - Part 1.mp4	9.1 MB
017 Purpose of a Staging Area in Data Warehouse Architecture - Part 2.mp4	7.8 MB
/quizzes/
003 Test your understanding on the Data Warehouse Architecutre.html	3.5 KB
/06 Dimensional Modeling/
018 What is Data Modeling.mp4	5.3 MB
019 Why should a Tester know Data Modeling.mp4	7.9 MB
020 Data Modeling Techniques.mp4	11.2 MB
021 ER Data Model.mp4	8.2 MB
022 Dimensional Model.mp4	10.0 MB
023 Differences between ER Model and Dimensional Model.mp4	15.7 MB
/.../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
025 Business Requirements.mp4	5.4 MB
026 CDM - Conceptual Data Model.mp4	5.1 MB
027 LDM - Logical Data Model.mp4	6.3 MB
028 Physical Data Model.mp4	2.7 MB
029 Database.mp4	7.8 MB
/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
031 What is a Fact Table.mp4	4.0 MB
032 Additive Facts.mp4	3.7 MB
033 Semi Additive Facts.mp4	5.0 MB
034 Non-Additive Facts.mp4	2.8 MB
035 Fact less Facts.mp4	4.9 MB
036 What is a Star Schema.mp4	10.7 MB
037 What is a Snow Flake Schema.mp4	7.0 MB
038 Galaxy Schema or Fact Constellation Schema.mp4	4.7 MB
039 Snow Flake Vs Star Schema.mp4	12.6 MB
040 Conformed Dimensions.mp4	12.3 MB
041 Junk Dimensions.mp4	5.5 MB
042 Degenerate Dimensions.mp4	7.4 MB
043 Role Playing Dimensions.mp4	4.3 MB
044 Slowly Changing Dimensions - Intro and Example Creation.mp4	11.4 MB
045 Slowly Changing Dimensions SCD Type 1 2 3.mp4	40.4 MB
046 Slowly Changing Dimensions - Summary.mp4	9.2 MB
/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
048 What is ETL.mp4	9.4 MB
049 Data Acquisition.mp4	9.4 MB
050 Data Transformation.mp4	13.3 MB
051 Common Questions and Summary.mp4	6.4 MB
/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
053 ELT - Explained.mp4	13.8 MB
054 ETL Vs ELT.mp4	4.8 MB
/11 Typical Roles In DWH Project/
055 Project Sponsor.mp4	10.5 MB
056 Project Manager.mp4	3.5 MB
057 Functional Analyst or Business Analyst.mp4	5.7 MB
058 SME - Subject Matter Expert.mp4	20.3 MB
059 DW BI Architect and Data Modeler.mp4	6.9 MB
060 DWH Tech Admin.mp4	2.7 MB
061 ETL Developers.mp4	4.3 MB
062 BI OLAP Developers.mp4	3.4 MB
063 ETL Testers QA Group.mp4	4.2 MB
064 DB UNIX Network Admins.mp4	2.1 MB
065 Data Architect Data Warehouse Architect BI Architect and Solution Architect.mp4	18.5 MB
066 Final Note about the Roles.mp4	4.2 MB
/quizzes/
007 Test your understanding on different roles in a DWH project.html	2.7 KB
/12 DWBIETL Implementation Approach/
067 Different phases in DWBIETL Implementation Approach.mp4	3.5 MB
068 Knowledge Capture Sessions.mp4	8.7 MB
069 Requirements.mp4	20.3 MB
070 Architecture Phase.mp4	10.5 MB
071 Data ModelDatabase.mp4	3.5 MB
072 ETL Phase.mp4	6.3 MB
073 Data Access Phase.mp4	5.4 MB
074 Data Access Types - Selection.mp4	4.0 MB
075 Data Access Types - Drilling Down.mp4	3.7 MB
076 Data Access Types - Exception Reporting.mp4	2.8 MB
077 Data Access Types - Calculations.mp4	4.8 MB
078 Data Access Types - Graphics and Visualization.mp4	2.7 MB
079 Data Access Types -Data Entry Options.mp4	4.7 MB
080 Data Access Types - Customization.mp4	2.3 MB
081 Data Access Types - WebBased Reporting.mp4	2.0 MB
082 Data Access Types - BroadCasting.mp4	4.0 MB
083 Deploy.mp4	4.0 MB
084 Iterative Approach.mp4	8.2 MB
/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
086 Test Strategy and Plan.mp4	7.4 MB
087 Define Test Framework.mp4	5.3 MB
088 Assess Source Target Components.mp4	9.4 MB
089 Test ETL - The Data Centric Method.mp4	7.0 MB
090 System and Integration Testing.mp4	12.2 MB
091 Regression Testing.mp4	8.7 MB
092 Performance Testing.mp4	9.6 MB
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
095 New DataWarehouse SetUp.mp4	6.7 MB
096 Migration Testing - Includes Data Migration.mp4	4.3 MB
097 Change Requests - For Existing Projects.mp4	3.8 MB
098 OLAPDashboardReport Testing.mp4	2.1 MB
/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
100 Analysis of the specifications provided by the clients.mp4	6.3 MB
101 Approve requirements and design specifications.mp4	3.0 MB
102 Create and Maintain the test strategy document.mp4	3.6 MB
103 Design the Test Cases as per the Test plan.mp4	4.1 MB
104 Estimate the efforts required to design the test cases and execute the project.mp4	2.8 MB
105 Tracability of requirements to test cases.mp4	2.4 MB
106 Define Exit and Entrance criteria.mp4	2.8 MB
107 Creating Test Plan Test Scenario Test Cases Test Scripts to validate source.mp4	4.3 MB
108 Test data creation.mp4	10.5 MB
109 Creating and Maintaining Reusable Scripts and Execute Test Scripts.mp4	3.3 MB
110 Execute backend data-driven test cases.mp4	4.2 MB
111 Client Co-ordination and Incorporate UAT Test cases and Identify Bugs.mp4	4.5 MB
112 Other Roles and Responsibilites.mp4	8.4 MB
113 INFOGRAPHIC The Roles Responsibilities of an ETL Tester ETL QA Analyst.html	3.2 KB
/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
115 Structural Database Testing.mp4	40.3 MB
116 Functional Database Testing.mp4	30.7 MB
117 Functional Database Testing - Part 2.mp4	14.7 MB
118 Non Functional Database Testing.mp4	9.9 MB
119 Summary of Database Testing.mp4	2.7 MB
/17 Basics of ETL Testing/
120 What is Data TestingETL Testing and the Challenges in ETL testing.mp4	12.7 MB
121 What will be the future of ETL toolstesting as big data is getting popular.mp4	20.6 MB
/.../120 What is Data TestingETL Testing and the Challenges in ETL testing/
ETL-testing-challenges.pdf	153.9 KB
/18 Database Testing Vs ETL Testing/
122 Database Testing and ETL Testing.mp4	9.1 MB
123 Differences between Database Testing and ETL Testing.mp4	2.5 MB
124 Database testing during ETL Testing - Explained with a project setup.mp4	9.5 MB
/19 Defect Management/
125 Bug Reports.mp4	4.6 MB
126 After Finding the Defect.mp4	7.0 MB
127 Writing the Bug Summary.mp4	3.9 MB
128 Using Appropriate LanguagePhrases.mp4	7.1 MB
129 Steps to Reproduce the Defect.mp4	6.6 MB
130 Including Test Data.mp4	1.6 MB
131 Including Screen Shots.mp4	3.5 MB
132 Severity Priority.mp4	2.2 MB
133 Logs.mp4	1.7 MB
134 Other Information.mp4	5.6 MB
/20 Possible Reasons for Defects Bugs/
135 Introduction to the common causes for defects.mp4	2.0 MB
136 InsufficientIncorrect Requirements.mp4	10.4 MB
137 AssumptionsMis-Understanding.mp4	5.7 MB
138 Wrong Decision During The Design.mp4	6.0 MB
139 Good Programmers With Wrong Goals.mp4	5.8 MB
140 Complexity.mp4	12.6 MB
141 Time Constriants.mp4	10.6 MB
142 Frequently Changing Business Requirements.mp4	4.5 MB
/quizzes/
011 Test your understanding on Possible Reasons for ETL bugs.html	2.3 KB
/21 IssuesDefect Management Process/
143 Reporting the discrepancy.mp4	12.9 MB
144 Communicating the discrepancy.mp4	6.1 MB
145 Escalating the discrepancy.mp4	3.5 MB
146 Generating Metrics.mp4	3.9 MB
/22 Issue Severity Table/
147 Critical Issue Severity.mp4	5.9 MB
148 High Severity Issues.mp4	3.2 MB
149 Medium Severity Issues.mp4	1.7 MB
150 Low Severity Issues.mp4	2.3 MB
/23 Quality Center Defect Category Descriptions/
151 Defect Status Category Labels.mp4	19.7 MB
/24 Categories of ETL Testing/
152 Metadata Testing.mp4	9.8 MB
153 Data Completeness Testing.mp4	10.1 MB
154 Data Quality Testing - Data Duplicates.mp4	16.5 MB
155 Data Quality Testing - Business Validation and Rules.mp4	15.7 MB
156 Data Transformation - White Box Testing.mp4	12.4 MB
157 Data Transformation - Black Box Testing.mp4	7.9 MB
158 ETL Regression Testing.mp4	5.5 MB
159 Reference Data Testing.mp4	13.3 MB
160 Incremental ETL Testing.mp4	7.5 MB
161 ETL Integration Testing.mp4	2.7 MB
162 ETL Performance Testing.mp4	5.0 MB
/.../162 ETL Performance Testing/
ETL-Testing-Categories.pdf	146.5 KB
/25 Different ToolsTechnologies used in DWHBIETL Testing/
163 Different Types of Enterprise Databases.mp4	11.3 MB
164 Different ETL tools available in the Market.mp4	12.8 MB
165 Which ETL tool should you learn if you are starting with ETL testing now.mp4	7.6 MB
/26 Informatica Power Center ETL Tool/
166 Informatica Power Center Architecture.mp4	45.7 MB
/27 Installation and Configuration of Informatica Power Center/
167 Pre Installation Steps System Pre-Requisites.mp4	43.9 MB
168 Quick Tip Product Availability Matrix - PAM.mp4	21.3 MB
169 Download Software.mp4	24.6 MB
170 Power Center Server Installation.mp4	38.3 MB
171 Power Center Client Installation.mp4	5.9 MB
172 Administration Console Introduction.mp4	35.6 MB
173 List of Services Available.mp4	44.8 MB
174 Repository Service Creation.mp4	48.0 MB
175 Setting up Integration Service.mp4	45.9 MB
/quizzes/
012 Test your understanding on the Informatica Power Center Setup.html	2.1 KB
/28 Informatica - Pre-Requisites to start the Hands on/
176 Repository Configuration and Folder Creation.mp4	32.8 MB
177 Basic File directory structures.mp4	35.1 MB
/29 Client Tools and Sample WorkFlow Creation/
178 Client Tools and Components.mp4	29.0 MB
179 Setting up the Database Connection at Mapping Designer and Workflow Manager.mp4	9.6 MB
180 Lets start with the Mapping Designer.mp4	24.1 MB
181 Mapping Designer - Finding Object Dependencies.mp4	8.3 MB
182 The Complete Cycle - Lets build the first Mapping Session and the Workflow.mp4	33.2 MB
/quizzes/
013 Test your understanding on Power Center Client Tools.html	2.1 KB
/30 Introduction to Transformations/
183 Transformations Overview.mp4	46.4 MB
184 Different Categories of Transformations.mp4	1.5 MB
185 Active Transformations.mp4	5.3 MB
186 Passive Transformations.mp4	5.8 MB
187 Connected Transformations and Unconnected Transformations.mp4	3.9 MB
188 Multi Group Transformations.mp4	3.3 MB
189 Restricted Process Transformations.mp4	2.7 MB
190 Data Flow Rules.mp4	13.5 MB
/31 Transformations functions in brief/
191 Brief introduction to Transformations and its functions.mp4	4.3 MB
192 Aggregator Trasformation.mp4	6.4 MB
193 Expression Transformation.mp4	4.9 MB
194 Filter Transformation.mp4	4.3 MB
195 Joiner Transformation.mp4	6.4 MB
196 Lookup Transformation.mp4	8.4 MB
197 Normalizer Transformation.mp4	3.8 MB
198 Rank Transformation.mp4	3.7 MB
199 Router Transformation.mp4	8.9 MB
200 Sequence Generator Transformation.mp4	5.3 MB
201 Stored Procedure Transformation.mp4	6.8 MB
202 Sorter Transformation.mp4	3.5 MB
203 Source Qualifier Transformation.mp4	6.0 MB
204 Update Strategy Transformation.mp4	7.2 MB
205 XML Source Qualifier Transformation.mp4	3.8 MB
206 XML Parser Transformation.mp4	3.7 MB
207 XML Generator Transformation.mp4	2.9 MB
208 Union Transformation.mp4	2.3 MB
209 HTTP Transformation.mp4	3.3 MB
210 Transaction Control Transformation.mp4	3.6 MB
211 Identity Resolution Transformation.mp4	2.8 MB
212 Custom Transformation.mp4	2.3 MB
213 Data Masking Transformation.mp4	2.4 MB
214 Additional Information about Informatica Power Center Transformations.mp4	9.7 MB
/32 Data Types in Informatica/
215 Power Centers Native Data Types and Data Type Conversion.mp4	14.4 MB
/33 Different Types of Ports in Informatica/
216 Ports in Informatica.mp4	14.0 MB
/34 Functions in Informatica/
217 Different Types of Functions.mp4	8.8 MB
218 Best ways to get around functions.mp4	12.8 MB
/35 Workflow Manager/
219 Components of Workflow Manager.mp4	17.4 MB
/36 Informatica PowerCenter Monitor/
220 Workflow Monitor.mp4	30.9 MB
221 Monitor Tools functionality Available Options.mp4	42.1 MB
222 Session Log.mp4	19.4 MB
/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
224 Mapplet.mp4	47.0 MB
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
227 Required Target Attributes based on the requirement.mp4	11.6 MB
228 Target Table creation based on the requirement.mp4	4.9 MB
229 Source Flat File Creation with the test data.mp4	6.6 MB
230 Source File directory for the source to be placed.mp4	9.5 MB
231 Lets create the mapping with the requirements at hand.mp4	72.0 MB
232 Workflow Creation for the mapping created with the requirements.mp4	12.5 MB
233 Different aspectsareas which needs to be verified during a workflow run.mp4	16.5 MB
234 What is S2T document and what should this document contain.mp4	14.4 MB
235 Source to Target Mapping - Sample 1.mp4	14.5 MB
236 Source to Target Mapping - Sample 2.mp4	13.1 MB
237 Source to Target Mapping - For the requirements we are using.mp4	39.5 MB
238 Technical Test Cases.mp4	40.7 MB
239 Verifying the workflow run and the source to target records.mp4	12.4 MB
240 Test Cases for Business and Data Validations.mp4	46.7 MB
241 Bug fixes for the issues identified.mp4	40.7 MB
242 Restarting the Workflow for further testing.mp4	7.2 MB
243 Duplicate Records Check and Record Count Verification.mp4	21.8 MB
244 Data Validation Checks - Using SQL queries Create Delete Drop Select Minus.mp4	44.8 MB
245 Test Case for verifying the Unique Sequence numbers.mp4	21.4 MB
246 Fix and Retest of the Active Flag scenario.mp4	11.7 MB
/.../226 Requirements for Flat File Source to Flat File and Relational Target/
Practical-Example-1.pdf	467.5 KB
/.../235 Source to Target Mapping - Sample 1/
sample.xlsx	10.7 KB
/.../236 Source to Target Mapping - Sample 2/
S2T.xlsx	23.2 KB
/.../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
248 Federated Architecture.mp4	6.5 MB
/
FreeTutorials.us.html	0.1 KB
[FreeTutorials.us].txt	0.1 KB
Total files 271