View Only

 How join data from excel and oracle table?

  • Pentaho
  • Pentaho
Manoj Kumar's profile image
Manoj Kumar posted 05-29-2021 14:38

I have some scenarios where data is present in .CSV file . For such records, I want to fetch the data from some oracle table and then perform the transformation. How to achieve that in pentaho data integration?. Please help.

Ana Gonzalez's profile image
Ana Gonzalez

You read the csv, you read the oracle table, sort the rows by the keys you want to use to join and merge the data of those inputs.