8 Replies Latest reply: Oct 10, 2012 5:30 AM by 966163 RSS

    OMB Plus - Properties of target tables and columns

    966163
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        Thank you so much !!!
                        It's perfect !

                        :))