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.
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.