AL_PARENT_CHILD

system · September 22, 2009, 11:08am

Hi, has anyone ever developed a SQL query to interogate this table in the repository? Am trying to easily identify which datastores are used by which job. Challenge is that we don’t always have the Job-Workflow-Dataflow-Datastore structure. Sometimes we have workflows nested within workflows (to several levels sometimes), in other cases we may have Job-Dataflow-Datastore, etc.

Unfortunately the metadata reporting (DI11.5) doesn’t provide the ability to show which datastores are used by which jobs (and v-v).

gpn01 (BOB member since 2004-11-30)

system · October 1, 2009, 4:54am

I managed to get a good information from the MetaData Tables

Simple, I used
AL_PARENT_CHILD
AL_LANG
AL_LANGTEXT

I used the Hierarchy Transform of DI and arrived at the Structure. It helped me a lot

ganeshxp (BOB member since 2008-07-17)

system · August 26, 2013, 6:45am

Any metadata table that holds the order of the Objects?
I assumed that the field DESCEN_OBJ_KEY of AL_PARENT_CHILD would serve the purpose…
But when a new object is placed in between the existing objects, it does not rearrange the order , but takes the max DESCEN_OBJ_KEY…

rajnia1 (BOB member since 2011-11-17)

system · August 26, 2013, 6:12pm

Your question isn’t quite the same as the one that started this thread. Therefore you should start a new thread. Hijacking someone’s thread is considered bad manners.

To get the order of objects you may have to look in AL_LANGTEXT.

eganjp (BOB member since 2007-09-12)