8 Replies Latest reply: Sep 8, 2009 2:18 PM by 710478 RSS

    Customizing Knowledge Module(KM) in ODI

    710478
      Hi,

      I am trying trying to customize the Knowledge Module(KM) to add new operation to the Interface,

      Let me explain the backgroound..

      Developed an interface in ODI to Fetch data from Source and move to Target table. After it Inserts/Updates in Target Table, IKM need to be modified to have one more operation to update back the STATUS_FLAG field in Source table as SUCCESS.

      In order to achieve this i want to pass the Values that fetched from the Query in "COMMAND ON TARGET"(this query is on Flow(I$) table from target) to "COMMAND ON SOURCE"(Updating STATUS_FLAG in actual Source table) where update is happening on source table.

      Please suggest me with your inputs..

      Thanks & Regards,
      Anil
        • 1. Re: Customizing Knowledge Module(KM) in ODI
          Guru Sankar
          Hi Anil,

          I will do that customization for you.

          Please,

          What is the IKM you are using?

          What is your source table structure?

          Thanks,
          G
          • 2. Re: Customizing Knowledge Module(KM) in ODI
            710478
            Thanks Guru,

            To explain more,

            Source : Oracle 10G Data base
            Target: SQL server 2005

            Goal is to Interface data from oracle to SQL Server and update back the STATUS_FLAG in Oracle Table as SUCCESS.

            My table structure is something like below..

            Table: x_odi_source_table
            -------------------------------------
            ID VARCHAR
            NAME VARCHAR
            EMP_SAL NUMBER
            ROLE NUMBER
            STATUS_FLAG VARCHAR


            KM used: IKM MSSQL Incremental Update

            Note1: Volumes of data per each run could be 10K records.

            Note2: I don't want new Interface that connects back from SQL Server 2005 to Oracle for this STATUS_FLAG Updation.


            Hope this will help.. Let me know if you need more details..

            Regards,
            Anil

            Edited by: user11338534 on Aug 26, 2009 12:59 PM
            • 3. Re: Customizing Knowledge Module(KM) in ODI
              Guru Sankar
              Hi Anil,

              Thanks for the details.

              Now i see, your source and target reside in two different environment.

              Well, some more questions i have,

              1. Is your oracle table xx_odi_source_table is a standard table for logging/flagging else you need to capture the source table name and connection details at run time before updating?

              1.1 If its dynamic, is the field name STATUS_FLAG is standard/constant?

              1.2 3. What is LKM you are using?

              2. What could be the values before loading in the STATUS_FLAG field?

              Thanks,
              G

              Edited by: Edited For Requirement understanding.
              • 4. Re: Customizing Knowledge Module(KM) in ODI
                710478
                Hi Guru,
                Here are my responses..

                Is your oracle table xx_odi_source_table is a standard table for logging/flagging else you need to capture the source table name and connection details at run time before updating?

                Ans: xx_odi_source_table Table is a Custom source table for that Interface. So if you consider a specific Interface, then data from Source Table xx_odi_source_table is picked and processed to Target(SQL Server) and then upon Inserting successfully in Target Table, an update statement needs to be added in IKM to Update the Column "Status_Flag" back in Source table as SUCCESS.

                1.1 If its dynamic, is the field name STATUS_FLAG is standard/constant?

                Ans: The field name STATUS_FLAG is same always in Source table. Only the data in it need to be modified.

                1.2 3. What is LKM you are using?

                Ans: LKM SQL to MSSQL

                2. What could be the values before loading in the STATUS_FLAG field?

                Ans: The field name STATUS_FLAG will initially have value as NULL. Once the data is interfaced to target it will have value as SUCCESS or ERROR if it is error in Interfacing.

                Pls let me know if you need any other details in understanding the issue.

                Regards,
                Anil
                • 5. Re: Customizing Knowledge Module(KM) in ODI
                  Guru Sankar
                  Hi Anil,

                  The customization has been done. Plesae share your email ID i will send you the steps and KM.

                  Thanks,
                  G
                  • 6. Re: Customizing Knowledge Module(KM) in ODI
                    710478
                    Thanks a Lot Guru.. My gmail ID <>

                    Edited by: user11338534 on Sep 8, 2009 12:18 PM
                    • 7. Re: Customizing Knowledge Module(KM) in ODI
                      710478
                      I'll confirm after testing
                      • 8. Re: Customizing Knowledge Module(KM) in ODI
                        710478
                        Works fine...Thaks Guru..