This discussion is archived
8 Replies Latest reply: Oct 10, 2012 3:30 AM by 966163 RSS

OMB Plus - Properties of target tables and columns

966163 Newbie
Currently Being Moderated
Hi,
I would like to write a OMB script to list for all my projects, modules and mappings, loading properties of target tables and columns.
But I don't know if it's possible and how can I do that.
I know realise loops in my projects, modules and mappings but I don't know which OMB function can pick up loading properties (tables : kind of load : Truncate/Insert..., and columns : change column for update : YES/NO, Change column for insert : YES/NO etc...)
Somebody can help me ?
Thank you very much !!!
  • 1. Re: OMB Plus - Properties of target tables and columns
    MccM Pro
    Currently Being Moderated
    Here you go, it's all here:



    http://docs.oracle.com/cd/E11882_01/owb.112/e14406/toc.htm

    http://docs.oracle.com/cd/E10926_01/doc/owb.101/b12152/toc.htm
  • 2. Re: OMB Plus - Properties of target tables and columns
    966163 Newbie
    Currently Being Moderated
    Thank you for your answer, however I'm really sorry but I don't find function to list criterias of loading.
    I'm just beginning in OMB plus ...
    Could you just tell me which one is to used ?
    Thank you very much for your help
  • 3. Re: OMB Plus - Properties of target tables and columns
    MccM Pro
    Currently Being Moderated
    It's something like...

    OMBRETRIEVE MAPPING $map OPERATOR $tab GROUP $grp ATTRIBUTE $col GET PROPERTIES(.....)
  • 4. OMB Plus - Properties of target tables and columns
    966163 Newbie
    Currently Being Moderated
    Thank you so much,
    but I d'ont really understand how can I use OMBRETRIEVE function.
    I don't know what $grp and $col are?
    My code below :

    #foreach projetname $projetlist {
         #puts "Nom Projet : $projetname"
         #puts $fname "Nom projet : $projetname "
         #OMBCC '$projetname'
         set modulist [ OMBLIST ORACLE_MODULES]

         foreach modname $modulist {
              puts "Module name : $modname"
              puts $fname "     Module name : $modname "
              OMBCC '$modname'
              set mapList [ OMBLIST MAPPINGS]

              foreach mapName $mapList {
                   puts "Map name :$mapName"
                   puts $fname "          map name : $mapName "
                   set tab [OMBRETRIEVE MAPPING '$mapName' GET PROPERTIES (TARGET_LOAD_ORDER)]
                   puts "Target table: $tab "
                   
                   OMBRETRIEVE MAPPING $mapName OPERATOR $tab GROUP $grp ATTRIBUTE $col GET PROPERTIES(.....)     
                        
              
              }
              OMBCC '..'
         }
    #OMBCC '..'
    #}

    Thank you, thank you, thank you !!!!
  • 5. Re: OMB Plus - Properties of target tables and columns
    MccM Pro
    Currently Being Moderated
    Check the documentation and look at sintax for OMBRETRIEVE. It's not that hard and I have no time to write scripts for you. Sorry.
  • 6. Re: OMB Plus - Properties of target tables and columns
    966163 Newbie
    Currently Being Moderated
    Thank you very much.
    You're right, I begin to understand how to use OMBRETRIEVE.
    I understand that to list column target properties I have to go in Mapping/operator/group/attribut
    So I can use attribut properties given in the documentation.
    However when I want to use these properties, I have en error message. OMB doesn't know these properties....

    foreach attribut $attributeList {
    set param1 [OMBRETRIEVE MAPPING '$mapName' OPERATOR '$Operator' GROUP '$group'  ATTRIBUTE '$attribut'\ GET PROPERTIES (LOAD_ON_INSERT) ];

    Do you know why ?
    Thank you very much
  • 7. Re: OMB Plus - Properties of target tables and columns
    MccM Pro
    Currently Being Moderated
    From documentation:

    Properties:


    LOAD_COLUMN_WHEN_INSERTING_ROW

    LOAD_COLUMN_WHEN_UPDATING_ROW

    MATCH_COLUMN_WHEN_DELETING_ROW

    MATCH_COLUMN_WHEN_UPDATING_ROW
  • 8. Re: OMB Plus - Properties of target tables and columns
    966163 Newbie
    Currently Being Moderated
    Thank you so much !!!
    It's perfect !

    :))

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points