1 - Welcome to the course.mp4 (13.68 MB)
MP4
CustomerData South.zip (3.55 KB)
ZIP
27 - Concepts Merging Data Streams.mp4 (19.84 MB)
MP4
28 - Sorted Merge Step Merging customer data.mp4 (99.77 MB)
MP4
29 - Merging product data.mp4 (65.63 MB)
MP4
30 - Append data stream merging sales data.mp4 (131.25 MB)
MP4
31 - Introduction to Data Cleansing.mp4 (21.38 MB)
MP4
32 - Value Mapper Step.mp4 (46.61 MB)
MP4
33 - Replace in String Step.mp4 (36.01 MB)
MP4
34 - Fuzzy Match concepts.mp4 (9.12 MB)
MP4
35 - Fuzzy Match Step in PDI.mp4 (104.49 MB)
MP4
36 - Fuzzy Match Algorithms.mp4 (45.53 MB)
MP4
37 - Formula Step and changing data format.mp4 (56.77 MB)
MP4
38 - Common Data Cleaning Steps.mp4 (13.04 MB)
MP4
39 - Introduction to Data validation.mp4 (19.77 MB)
MP4
40 - Datavalidation 1 StringtoInt and integer range validations.mp4 (152.03 MB)
MP4
41 - Data validation 2 Checking Reference Values using stream lookup.mp4 (88.86 MB)
MP4
42 - Data validation 3 Order date shipping date using calculator step.mp4 (43.14 MB)
MP4
43 - Common Data Validation steps.mp4 (14.04 MB)
MP4
44 - Correcting the errors and merging with main stream.mp4 (109.34 MB)
MP4
45 - Writing the errors to the log.mp4 (19.03 MB)
MP4
46 - Writing the errors to a separate file.mp4 (56.28 MB)
MP4
47 - Concatenating Address Fields.mp4 (40.8 MB)
MP4
48 - Data Aggregation using Groupby.mp4 (56.6 MB)
MP4
49 - Normalization and Denormalization.mp4 (30.28 MB)
MP4
50 - Number Range Step.mp4 (25.29 MB)
MP4
51 - Introduction to PDI SQL connection.mp4 (21.45 MB)
MP4
52 - Reading and filtering data from DB into PDI.mp4 (16.11 MB)
MP4
53 - Updating and Inserting data into DB from PDI.mp4 (33.37 MB)
MP4
54 - Deleting data from SQL DB using PDI.mp4 (19.34 MB)
MP4
55 - Facts and Dimensions tables.mp4 (13.1 MB)
MP4
56 - Surrogate Keys in Dimension tables.mp4 (12.92 MB)
MP4
57 - Type 1 2 Slowly Changing Dimensions.mp4 (9.61 MB)
MP4
58 - Schemas.mp4 (9.94 MB)
MP4
59 - Creating tables in DB.mp4 (29.25 MB)
MP4
60 - Loading Customer Data using combination lookup update step.mp4 (87.85 MB)
MP4
61 - Loading product data using dimension lookup step.mp4 (74.81 MB)
MP4
62 - Loading sales data after database lookup steps.mp4 (92.23 MB)
MP4
63 - Scripting Steps.mp4 (26.43 MB)
MP4
64 - PDI Jobs vs Transformation.mp4 (8.2 MB)
MP4
65 - Controlling the flow of execution.mp4 (16.83 MB)
MP4
66 - Setting variables using set variables step.mp4 (41.84 MB)
MP4
67 - File and Folder Management.mp4 (27.01 MB)
MP4
68 - Sending Email Step.mp4 (39.31 MB)
MP4
69 - Abort Job Step.mp4 (13.1 MB)
MP4
3 - Setting up environment and installing PDI.mp4 (33.43 MB)
MP4
4 - This is a milestone.mp4 (26.14 MB)
MP4
5 - Opening Spoon The Graphical UI.mp4 (34.19 MB)
MP4
70 - Running using command prompt and scheduling.mp4 (40.88 MB)
MP4
71 - Metadata injection.mp4 (90.05 MB)
MP4
72 - Regular Expressions for advanced String Matching.mp4 (112.05 MB)
MP4
74 - The final milestone.mp4 (8.36 MB)
MP4
6 - The example problem statement.mp4 (29.85 MB)
MP4
7 - Demonstration of a PDI transformation.mp4 (178.92 MB)
MP4
8 - Demonstration of a PDI Job.mp4 (115.2 MB)
MP4
10 - Data Warehouse Ops Database and Data mart.mp4 (17.81 MB)
MP4
11 - Inmon vs Kimball Architecture.mp4 (13.59 MB)
MP4
12 - ETL vs ELT.mp4 (8.73 MB)
MP4
9 - What is ETL.mp4 (11.35 MB)
MP4
13 - Data and the ETL process.mp4 (105.31 MB)
MP4
14 - Manually entering data into PDI.mp4 (88.28 MB)
MP4
15 - Inputting Data from a TXT text file.mp4 (115.5 MB)
MP4
16 - Input from multiple CSV files at the same time.mp4 (109.22 MB)
MP4
17 - Inputting Data from an Excel file.mp4 (34.43 MB)
MP4
18 - Extracting Data from Zipped files.mp4 (30.62 MB)
MP4
19 - Extracting from XML.mp4 (68.26 MB)
MP4
20 - Extracting from JSON.mp4 (62.83 MB)
MP4
21 - Plan for importing sales data.mp4 (7.76 MB)
MP4
22 - Installing PostgreSQL and pgAdmin in your PC.mp4 (68.31 MB)
MP4
23 - Creating Sales table in SQL.mp4 (53.2 MB)
MP4
24 - Extracting from an SQL table.mp4 (28.51 MB)
MP4
25 - Storing Data on AWS S3.mp4 (66.95 MB)
MP4
26 - Reading data from AWS S3.mp4 (69.26 MB)
MP4