Thread: OWB 10.2 script OMB+ to list mapping operator type


Permlink Replies: 2 - Pages: 1 - Last Post: Dec 4, 2006 2:21 PM Last Post By: wmakruf
bliberati

Posts: 14
Registered: 09/04/06
OWB 10.2 script OMB+ to list mapping operator type
Posted: Sep 18, 2006 8:31 AM
Click to report abuse...   Click to reply to this thread Reply
Hi all,

I'm using OWB 10gR2 and I want run an OMB+ script to list all operators (name and type) for all mappings in a project.

With some loops in TCL, I can list mappings with OMBLIST MAPPINGS

For each mapping, I can list operators with OMBRETRIEVE MAPPING 'map name' GET OPERATORS, and get the name.

But now I can't find properties list for operator in OMB+ help. I can list properties values for operators with OMBRETRIEVE MAPPING 'map name' OPERATOR 'op name' GET PROPERTIES (property name, property name, ...).

Somebody nows how to find this list?

Thank you
M.Boire

Posts: 66
Registered: 08/30/05
Re: OWB 10.2 script OMB+ to list mapping operator type
Posted: Sep 18, 2006 10:54 AM   in response to: bliberati in response to: bliberati
Click to report abuse...   Click to reply to this thread Reply
The documentation would need some updating for sure... and a command to retrieve all the properties for each level would indeed be nice.

I you go in OWB Client, select a mapping, "Configure"
Then you have access to each properties of the mapping, basically the property name for OMBPLUS will be what you see , UPPERCASE and underscore between the words.

example:
BOUND_NAME
SCHEMA
DATABASE_LINK
PEL_ENABLED
DATA_COLLECTION_FREQUENCY
DIRECT
REPLACE_DATA
EXTRACTION_HINT
LOADING_HINT
ENABLE_CONSTRAINTS
EXCEPTIONS_TABLE_NAME
PARTITION_NAME
SUBPARTITION_NAME
SORTED_INDEX_CLAUSE
SINGLEROW
TRAILING_NULLCOLS
RECORDS_TO_SKIP
DATABASE_FILE_NAME
wmakruf

Posts: 3
Registered: 03/13/01
Re: OWB 10.2 script OMB+ to list mapping operator type
Posted: Dec 4, 2006 2:21 PM   in response to: bliberati in response to: bliberati
Click to report abuse...   Click to reply to this thread Reply
Hi,

It is possible with OMBDESRIBE CLASS_DEFINITION.
eg.

OMBDESCRIBE CLASS_DEFINITION 'TABLE_OPERATOR' GET PROPERTY_DEFINITIONS

==>
ADVANCED_MATCH_BY_CONSTRAINT BOUND_NAME BUSINESS_NAME .....
....
UOID USE_LCR_API

Regards

Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums