Get Transformation details using a table name in PDI Pentaho

Question

I know my database table name and it is being used in one of the transformation in Pentaho PDI transformations which is inside a job. But I don't know where else the same table is used in other transformations of my repo. Is there a way to find the list of transformations where all the same table is used by some search or meta data find?

Answer 1

PDI transformations and jobs are xml files with a different extension, so any methods your OS allows to search for content inside text files will work, for example, grep in Linux.

Answer 2

Ana's answer before is the normal and correct answer.

However sometimes grep is not a real option, for example if you have a lot of tables with the same names in diffrent systems, or if you have the same table in diffrent schema (in case of for example in a multitenant postgreql databaseserver). A dirty but easy way to find out is then on a test environment, just alter one character in the table name and see which transformation throws an error.

On another note, if your code is so clouded that you can't retrace where a certain table is being used, then you might have some other issues in your design...