5 Replies Latest reply on Apr 16, 2007 6:32 PM by 572407

    DVM setup and usage

    572407
      iStudio Gurus, I need some help.

      I have an outbound message that contains elements COUNTRY and STATE. The receiving system needs COUNTRY_ID and STATE_ID. I have set up two DVMs - one that takes COUNTRY and translates to a number, and another that takes a combination of COUNTRY and STATE and translates to a number. However, when I view the log file, the transformation results in NULL. My DVM data looks like:

      0     US     840
      0     DJ     262
      0     GU     316, for COUNTRY

      and
      0     US,AL     1
      0     US,AZ     2
      0     US,AR     3 for STATE.

      Any ideas what I may be doing wrong?

      Thanks,
      Sunder
        • 1. Re: DVM setup and usage
          159563
          If I'm not mistaken DVM can't be use for multiply mappings, I mean field1+field2->field3.
          DVM is a table in the repository with N-columns where N is number of applications using this DVM:
          Appl1 Appl2 Appl3
          id1 id2 id3

          What is your actual DVM contents?
          • 2. Re: DVM setup and usage
            572407
            Thanks for you response. I created the DVM for 2 applications - AppsD2App and MGTD1App. The two tables that exist in the interConnect repository corresponding to the two DVMs are DVM_TCA_MGT_STATEMASTER and DVM_TCA_MGT_COUNTRYMASTER.

            create table DVM_TCA_MGT_STATEMASTER
            (
            DUMMY NUMBER(1),
            APPSD2APP VARCHAR2(4000),
            MGTD1APP VARCHAR2(4000)
            );

            Sample rows:
            Dummy AppsD2App MGTD1App
            0 US,AL 1
            0 US,AZ 2


            create table DVM_TCA_MGT_COUNTRYMASTER
            (
            DUMMY NUMBER(1),
            APPSD2APP VARCHAR2(4000),
            MGTD1APP VARCHAR2(4000)
            );
            Sample rows:
            Dummy AppsD2App MGTD1App
            0 US 840
            0 DJ 262
            • 3. Re: DVM setup and usage
              159563
              Now what is your problem?
              • 4. Re: DVM setup and usage
                572407
                I am expecting to see the value "840" in COUNTRY_ID when my message contains "US" in COUNTRY, but I always get NULL. So, I'm definitely missing something in my setup.
                • 5. Re: DVM setup and usage
                  572407
                  Never mind. Classic case of PEBCAK - Problem Exists between Chair and Keyboard. I was running the transform on the publishing side instead of the subscribing side.

                  For the multi-column lookup, I did a 2-step transformation - step 1 to concat the two columns on the publishing side, step 2 to do a DVM lookup on the subscribing side