👉5. Pentaho ETL Lookup Functionality | Complete Step-by-Step Guide + Examples ✔️
This video is part of a complete Pentaho course that you can access by following this link: • OUTLOOK CORREO DE RESPUESTA AUTOMATICA
Whether you're just starting out or already have experience with Pentaho Spoon (PDI), this tutorial will help you improve your data transformation processes.
Don't forget to subscribe for more ETL and Big Data tutorials!
00:14 5.1. Introduction to LOOKUP functions
01:15 5.2. CHECK IF A COLUMN EXISTS option
05:11 5.3. FILE EXIST option
06:50 5.4. STREAM LOOKUP option
10:11 5.5. DATABASE JOIN option
15:49 5.6. DATABASE LOOKUP option
21:05 5.7. TABLE EXIST option
24:04 5.8. Dynamic SQL Row Option
Hashtags:
#PentahoDataIntegration #PDI #ETL #InputTools #PentahoSpoon #DataIntegration #Database #BigData #BusinessIntelligence #DataIntegration
If my content has been helpful, please consider making a small donation to support this channel and help me continue creating content.
https://www.paypal.com/donate/?cmd=_d...
TAGS:
pentaho lookup,
pentaho lookup tools,
pentaho lookup,
bi,
business intelligence,
business intelligence course,
business intelligence,
pentaho data integration course,
data integration,
data science,
etl,
kettle,
pentaho utility options,
step by step,
pdi,
pentaho,
pentaho analysis services,
bi pentaho,
pentaho community data integration tutorial,
pentaho data integration,
pentaho data integration tutorial,
pentaho kettle spoom pdi,
pentaho spoon,
pentaho tutorial,
spoon,
check if a column exists,
file exists,
stream lookup,
database join,
database lookup,
table exists,
dynamic sql row,