How to get a list of input/output objects to a mapping [message #167171] |
Tue, 11 April 2006 10:58 |
camaleus
Messages: 1 Registered: April 2006
|
Junior Member |
|
|
hi all,
I'm working on the maintenance of a DWH project which is based on OWB and contains about 1500 mappings.
I have the following need: the application relies on a scheduler customized and deeloped from the customer. The scheduler is based on parameter tables which contains the information about mappings in order to execute them.
I need to automate the way to verify alignment between the real mappings and the parameter table, and i was checking if there is any way to extract the information from the CMPALLCLASSES system table or any other view based on it.
For example we have a table containing for each mapping the list of objects in input to and output from the mapping. And It's really crazy to think of double-clicking on each mapping through the client interface.... I hope there is a way to extract the info....anyone can help me, before driving crazy??????
thanx in advance
marco
|
|
|
|