Skip to main content
Side panel
Call us : 024-2662350
E-mail :
it@huph.edu.vn
You are currently using guest access (
Log in
)
Trang chủ HUPH
Microsoft Teams
Các khóa học
Tài nguyên
Google Classroom
Videos học tập
Hướng dẫn
Hướng dẫn sử dụng LMS (dành cho giảng viên)
Hướng dẫn sử dụng LMS (dành cho học viên)
Hướng dẫn sử dụng Microsoft Team cho giảng viên
Hướng dẫn sử dụng Microsoft Team cho sinh viên
Hướng dẫn soạn thảo bài giảng Elearning
English (en)
English (en)
Vietnamese (vi)
Learning Pentaho
Home
Courses
Data Science Courses
pentaho
17. Loading the data into a Data Mart
2. Loading Customer Data using combination lookup update step
2. Loading Customer Data using combination lookup update step
Last modified: Friday, 16 April 2021, 9:23 AM
◄ 1. Creating tables in DB
Jump to...
Jump to...
1. Welcome to the course
2. Course Resources
1. Setting up environment and installing PDI
2. Opening Spoon - The Graphical UI
1. The example problem statement
2. Demonstration of a PDI transformation
3. Demonstration of a PDI Job
1. What is ETL
2. Data Warehouse, Ops Database and Data mart
3. Inmon vs Kimball Architecture
4. ETL vs ELT
1. Data and the ETL process
1. Manually entering data into PDI
2. Inputting Data from a TXT (text) file
3. Input from multiple CSV files at the same time
4. Inputting Data from an Excel file
5. Extracting Data from Zipped files
1. Extracting from XML
2. Extracting from JSON
1. Plan for importing sales Data
2. Installing and setting up PostgreSQL
3. Creating Sales table in SQL
4. Extracting from an SQL table
1. Storing Data on AWS S3
2. Reading data from AWS S3
1. Concepts Merging Data Streams
2. Sorted Merge Step - Merging customer data
3. Merging product data
4. Append data stream - merging sales data
1. Introduction to Data Cleansing
2. Value Mapper Step
3. Replace in String Step
4. Fuzzy Match concepts
5. Fuzzy Match Step in PDI
6. Fuzzy Match Algorithms
7. Formula Step and changing data format
8. Common Data Cleaning Steps
1. Introduction to Data validation
2. Data_validation 1 - String-to-Int and integer range validations
3. Data validation 2 - Checking Reference Values using stream look-up
4. Data validation 3 - Order date shipping date using calculator step
5. Common Data Validation steps
1. Correcting the errors and merging with main stream
2. Writing the errors to the log
3. Writing the errors to a separate file
1. Concatenating Address Fields
2. Data Aggregation using Group-by
3. Normalization and Denormalization
4. Number Range Step
1. Introduction to PDI - SQL connection
2. Reading and filtering data from DB into PDI
3. Updating and Inserting data into DB from PDI
4. Deleting data from SQL DB using PDI
1. Facts and Dimensions tables
2. Surrogate Keys in Dimension tables
3. Type 1 & 2 Slowly Changing Dimensions.
4. Schemas
1. Creating tables in DB
3. Loading product data using dimension lookup step
4. Loading sales data after database lookup steps
1. Scripting Steps
1. PDI Jobs vs Transformation
2. Controlling the flow of execution
3. Setting variables using set variables step
4. File and Folder Management
5. Sending Email Step
6. Abort Job Step
1. Running using command prompt and scheduling
1. Metadata injection
1. Regular Expressions for advanced String Matching
3. Loading product data using dimension lookup step ►
pentaho
1. Introduction
2. Pentaho Data Integration (PDI) Installation and Setup
3. A Simple ETL Demonstration
4. Basic concepts - Theory for foundational understanding
5. The ETL process The practical part begins here
6. DATA EXTRACTION Extracting tabular data
7. DATA EXTRACTION Extracting non-tabular data
8. Extracting from an SQL table
9. Storing and Retrieving Data from Cloud storage
10. Merging Data Streams
11. Data Cleansing
12. Data Validation
13. Error Handling
14. Transformation and Analytics steps
15. PDI SQL Connection
16. Conceptual understanding for Loading Data
17. Loading the data into a Data Mart
18. Running Java and Javascript
19. PDI Jobs
20. Scheduling a job for production environment
21. Metadata injection
22. Regex Notation
Home
Calendar