Sunday, March 29, 2009

Operator Type at runtime - OMB command

It's possible to get all the operator names within a mapping.
It's possible to list operator names as per operator type like Joiner, Sorter, Filter,etc within a mapping.

While coding an OMB script, i needed an OMB command to find the operator type from operator name at runtime.

How can we get Operator Type ( whether its a joiner,cube,dimension,etc) from the operator name within a mapping ?

Undocumented Operator property "STRONG_TYPE_NAME" can be used to get it.

Command:-
OMBRETRIEVE MAPPING 'MAPPING_NAME' OPERATOR 'OPERATOR_NAME' GET PROPERTIES (STRONG_TYPE_NAME)

Result:-
oracle.wh.service.impl.mapping.component.Join (If the operator is Joiner )

oracle.wh.service.impl.mapping.component.Cube (If the operator is Cube )

and so on...


A TCL logic needs to written to parse the result string ( get the last word after the last period "." ) .

No comments:

Post a Comment