Community,

I've activated logging from all angles of my job(s) and transformation(s). We are not using a repository, so I am left with
a handful of tables I am trying to join together to make sense of things.

I have two primary challenges :

1. I am struggling to reverse engineer a single SQL statement joining up multiple tables properly....based on channel_id
2. Contents of the various tables show up at different times...making it difficult for me to understand which tables
can be used intra-process and which are best left for inter-process (after the job completes/exits).

If I had a schematic of the PDI logging schema/tables, with keys I could solve (1). If I could functional queries used by others
I could tackle (2).

Happy to share what I come up with - if it hasn't already been shared - if someone would like to pitch in.

Thanks,

Michael