Operational Metadata

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Raftsman
Premium Member
Premium Member
Posts: 335
Joined: Thu May 26, 2005 8:56 am
Location: Ottawa, Canada

Operational Metadata

Post by Raftsman »

We have a requirement to extract and load the Operational Metadata into a Operational Data Mart. We are using Oracle 10g to store the Xmeta schema. I have looked through the tables trying to make sense on where the job information resides. Still haven't found it. I turned on the "Generate Operational Metadata" box in Administrator but I don't no where the information is stored. I read the manual and it tell me to create a MetaStage Loc Info TABLE. Not sure what this is for as the instructions are very vague.

Has anyone gathered this information for reporting purposes and if so, could you please shead some light on the situation.

I contacted IBM but it is low priority and I am not receiveing a very quick response. I am hoping some in this forum could help

Thanks
Jim Stewart
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Do a search for EtlStats.
Mamu Kim
Post Reply