Run time optimisation of Pentaho PDI transformation

Question

I'm running this transformation in PDI and it took me hours to load table that contains 18000 record .

SQL query in the iput table step :

Is it normal or should I try to optimize the SQL query or add more steps ??

Answer 1

I think your sql code is not effective. You should not to cast column, and should cast the parameter only. Sometimes, cast column is so expensive.