Pentaho for ETL Data Integration Masterclass 2020 PDI | 24437716E4639511D9CB200DE65C651E10A3D506

Pentaho for ETL Data Integration Masterclass 2020 PDI

Name	Pentaho for ETL & Data Integration Masterclass 2020- PDI 9.0	DOWNLOAD Copy Link
Total Size	3.4 GB
Total Files	144
Last Seen	2024-07-22 23:56
Hash	24437716E4639511D9CB200DE65C651E10A3D506

/.../3. A Simple ETL Demonstration/
2. Demonstration of a PDI transformation.mp4	143.4 MB
1. The example problem statement.mp4	35.0 MB
1. The example problem statement.srt	7.8 KB
2. Demonstration of a PDI transformation.srt	23.2 KB
3. Demonstration of a PDI Job.mp4	82.5 MB
3. Demonstration of a PDI Job.srt	18.2 KB
/
TutsNode.com.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/1. Introduction/
1. Welcome to the course.mp4	25.9 MB
1. Welcome to the course.srt	4.5 KB
2. Course Resources.html	0.4 KB
/.../2. Pentaho Data Integration (PDI) Installation and Setup/
1. Setting up environment and installing PDI.mp4	38.0 MB
1. Setting up environment and installing PDI.srt	5.4 KB
2. Opening Spoon - The Graphical UI.mp4	36.8 MB
2. Opening Spoon - The Graphical UI.srt	7.7 KB
/.../4. Basic concepts - Theory for foundational understanding/
1. What is ETL.mp4	14.7 MB
1. What is ETL.srt	3.7 KB
2. Data Warehouse, Ops Database and Data mart.mp4	25.0 MB
2. Data Warehouse, Ops Database and Data mart.srt	5.7 KB
3. Inmon vs Kimball Architecture.mp4	19.9 MB
3. Inmon vs Kimball Architecture.srt	4.0 KB
4. ETL vs ELT.mp4	11.7 MB
4. ETL vs ELT.srt	3.3 KB
/.../5. The ETL process The practical part begins here/
1. Data and the ETL process.mp4	75.6 MB
1. Data and the ETL process.srt	10.5 KB
/.../6. DATA EXTRACTION Extracting tabular data/
1. Manually entering data into PDI.mp4	64.3 MB
1. Manually entering data into PDI.srt	11.3 KB
2. Inputting Data from a TXT (text) file.mp4	95.7 MB
2. Inputting Data from a TXT (text) file.srt	13.3 KB
3. Input from multiple CSV files at the same time.mp4	90.6 MB
3. Input from multiple CSV files at the same time.srt	14.4 KB
4. Inputting Data from an Excel file.mp4	53.4 MB
4. Inputting Data from an Excel file.srt	7.0 KB
5. Extracting Data from Zipped files.mp4	41.8 MB
5. Extracting Data from Zipped files.srt	6.9 KB
/.../7. DATA EXTRACTION Extracting non-tabular data/
1. Extracting from XML.mp4	59.7 MB
1. Extracting from XML.srt	6.7 KB
2. Extracting from JSON.mp4	43.6 MB
2. Extracting from JSON.srt	5.5 KB
/.../8. Extracting from an SQL table/
1. Plan for importing sales Data.mp4	11.0 MB
1. Plan for importing sales Data.srt	3.3 KB
2. Installing and setting up PostgreSQL.mp4	61.5 MB
2. Installing and setting up PostgreSQL.srt	8.8 KB
3. Creating Sales table in SQL.mp4	59.6 MB
3. Creating Sales table in SQL.srt	9.5 KB
4. Extracting from an SQL table.mp4	37.7 MB
4. Extracting from an SQL table.srt	5.8 KB
/.../9. Storing and Retrieving Data from Cloud storage/
1. Storing Data on AWS S3.mp4	53.5 MB
1. Storing Data on AWS S3.srt	5.9 KB
2. Reading data from AWS S3.mp4	57.5 MB
2. Reading data from AWS S3.srt	8.2 KB
/.../10. Merging Data Streams/
1. Concepts Merging Data Streams.mp4	30.0 MB
1. Concepts Merging Data Streams.srt	8.0 KB
2. Sorted Merge Step - Merging customer data.mp4	121.5 MB
2. Sorted Merge Step - Merging customer data.srt	18.8 KB
3. Merging product data.mp4	71.7 MB
3. Merging product data.srt	10.2 KB
4. Append data stream - merging sales data.mp4	109.3 MB
4. Append data stream - merging sales data.srt	11.8 KB
/.../11. Data Cleansing/
1. Introduction to Data Cleansing.mp4	31.3 MB
1. Introduction to Data Cleansing.srt	7.8 KB
2. Value Mapper Step.mp4	58.4 MB
2. Value Mapper Step.srt	6.5 KB
3. Replace in String Step.mp4	39.8 MB
3. Replace in String Step.srt	6.1 KB
4. Fuzzy Match concepts.mp4	12.5 MB
4. Fuzzy Match concepts.srt	3.5 KB
5. Fuzzy Match Step in PDI.mp4	82.8 MB
5. Fuzzy Match Step in PDI.srt	11.1 KB
6. Fuzzy Match Algorithms.mp4	38.0 MB
6. Fuzzy Match Algorithms.srt	9.5 KB
7. Formula Step and changing data format.mp4	62.8 MB
7. Formula Step and changing data format.srt	10.4 KB
8. Common Data Cleaning Steps.mp4	18.1 MB
8. Common Data Cleaning Steps.srt	4.0 KB
9. Quiz.html	0.2 KB
/.../12. Data Validation/
1. Introduction to Data validation.mp4	24.6 MB
1. Introduction to Data validation.srt	5.7 KB
2. Data_validation 1 - String-to-Int and integer range validations.mp4	95.4 MB
2. Data_validation 1 - String-to-Int and integer range validations.srt	11.7 KB
3. Data validation 2 - Checking Reference Values using stream look-up.mp4	70.6 MB
3. Data validation 2 - Checking Reference Values using stream look-up.srt	9.0 KB
4. Data validation 3 - Order date shipping date using calculator step.mp4	54.7 MB
4. Data validation 3 - Order date shipping date using calculator step.srt	5.6 KB
5. Common Data Validation steps.mp4	19.7 MB
5. Common Data Validation steps.srt	4.5 KB
/.../13. Error Handling/
1. Correcting the errors and merging with main stream.mp4	72.5 MB
1. Correcting the errors and merging with main stream.srt	12.2 KB
2. Writing the errors to the log.mp4	27.6 MB
2. Writing the errors to the log.srt	3.6 KB
3. Writing the errors to a separate file.mp4	41.7 MB
3. Writing the errors to a separate file.srt	6.0 KB
/.../14. Transformation and Analytics steps/
1. Concatenating Address Fields.mp4	56.1 MB
1. Concatenating Address Fields.srt	5.8 KB
2. Data Aggregation using Group-by.mp4	70.4 MB
2. Data Aggregation using Group-by.srt	8.0 KB
3. Normalization and Denormalization.mp4	39.7 MB
3. Normalization and Denormalization.srt	7.2 KB
4. Number Range Step.mp4	29.1 MB
4. Number Range Step.srt	4.8 KB
/.../15. PDI SQL Connection/
1. Introduction to PDI - SQL connection.mp4	29.5 MB
1. Introduction to PDI - SQL connection.srt	6.6 KB
2. Reading and filtering data from DB into PDI.mp4	20.9 MB
2. Reading and filtering data from DB into PDI.srt	5.6 KB
3. Updating and Inserting data into DB from PDI.mp4	42.8 MB
3. Updating and Inserting data into DB from PDI.srt	8.7 KB
4. Deleting data from SQL DB using PDI.mp4	19.5 MB
4. Deleting data from SQL DB using PDI.srt	3.9 KB
/.../16. Conceptual understanding for Loading Data/
1. Facts and Dimensions tables.mp4	19.3 MB
1. Facts and Dimensions tables.srt	3.6 KB
2. Surrogate Keys in Dimension tables.mp4	18.4 MB
2. Surrogate Keys in Dimension tables.srt	4.1 KB
3. Type 1 & 2 Slowly Changing Dimensions.mp4	13.4 MB
3. Type 1 & 2 Slowly Changing Dimensions.srt	3.5 KB
4. Schemas.mp4	13.5 MB
4. Schemas.srt	3.9 KB
/.../17. Loading the data into a Data Mart/
1. Creating tables in DB.mp4	41.2 MB
1. Creating tables in DB.srt	8.2 KB
2. Loading Customer Data using combination lookup update step.mp4	87.8 MB
2. Loading Customer Data using combination lookup update step.srt	15.3 KB
3. Loading product data using dimension lookup step.mp4	81.8 MB
3. Loading product data using dimension lookup step.srt	12.6 KB
4. Loading sales data after database lookup steps.mp4	70.9 MB
4. Loading sales data after database lookup steps.srt	9.4 KB
/.../18. Running Java and Javascript/
1. Scripting Steps.mp4	32.8 MB
1. Scripting Steps.srt	7.1 KB
/.../19. PDI Jobs/
1. PDI Jobs vs Transformation.mp4	11.2 MB
1. PDI Jobs vs Transformation.srt	3.1 KB
2. Controlling the flow of execution.mp4	21.8 MB
2. Controlling the flow of execution.srt	5.5 KB
3. Setting variables using set variables step.mp4	33.9 MB
3. Setting variables using set variables step.srt	7.2 KB
4. File and Folder Management.mp4	34.2 MB
4. File and Folder Management.srt	8.0 KB
5. Sending Email Step.mp4	32.9 MB
5. Sending Email Step.srt	7.1 KB
6. Abort Job Step.mp4	16.1 MB
6. Abort Job Step.srt	4.0 KB
/.../20. Scheduling a job for production environment/
1. Running using command prompt and scheduling.mp4	39.9 MB
1. Running using command prompt and scheduling.srt	6.9 KB
/.../21. Metadata injection/
1. Metadata injection.mp4	69.5 MB
1. Metadata injection.srt	13.7 KB
/.../22. Regex Notation/
1. Regular Expressions for advanced String Matching.mp4	88.8 MB
1. Regular Expressions for advanced String Matching.srt	15.6 KB
Total files 144