How can I get SQL for whole transformation.

[zealotgurung]

I am trying to get the sql statements for the whole process so that I can use the sql statements without having to run pan. Is there a way I can get the SQL statements for a transformation or a job? I am kind of lost when looking at the source codes and need to figure out if there is a class definition that holds sql parsed from the xml file.

Need something like xml to sql converter if any..

Thanks

[buachaille]

Try changing the logging level to "Row-level" when executing the job or transformation. You should see the SQL (along with _lots_ of debugging info) in the Execution Results "Logging" section.

Cheers,
Paul

[gutlez]

Note that PDI can be doing more than just running a series of SQL statements, so the statements will not necessarily help you.

for example if you just get the SQL statements, you might end up with:
SELECT * FROM table1
INSERT value5 INTO table2

But unless you know the transform, there could be group by steps, or calculators, or many other things that change what those values are. There is also the possibility that one or the other SQL statement is looping - which also changes the process.

In short, runnning pan is likely your easiest solution.