This step-by-step hands-on article walks you through PDI tool installation, SQL JDBC Driver setup and carries out a very basic ETL process to transform a sample csv file into dimensional model. We hope to provide yet another article on dimensional modeling.
Tag: ETL Process
ETL is the process of gathering data from an unlimited number of sources, organizing it together, and centralizing it into a single repository to get the final business insight. Some people perform ETL through hand coding in SQL or Java, but there are tools available that simplify the process.