** Not able to create Value Mapping Table in Integration Directory

[jegathees_waran]

Hi friends,

I am not able to create value mapping entries like below in ID.

-

---

Agency : Computer1 Agency : Computer2

Scheme: Country Scheme: CountryCode

Value for Computer1 Value for Computer2

Australia AU

India IN

Austria AU

-

---

Note that I have assigned the same country code 'AU' for the Countries 'Australia' & 'Austria'. But, when we assign 'AU' to 'Austria', the system asks question as below:

-

---

Value mapping already exists

Australia | AU

Austria | AU

Do you want to delete it from the existing group and assign it to the current group instead?

Continue Cancel

-

---

Though choose any of the option, I am not able to assign 'AU' to 'Austria'.

Friends, this is my requirement. How do we solve this ?

Kindly help me.

Kind Regards,

Jeg P.

[jegathees_waran]

Hi Kulkarni,

Yes, it is possible thru Fix Values. But, we are instructed to use XSLT mapping and call VM table in the ID thru Java Function.that is the problem.

[Former Member]

Jegatheeswaran,

Did you try the approach I suggested. To be sure I tried this myself, and it gives a warning but allows you to enter the duplicates.

Kind regards,

Koen

[jegathees_waran]

Hi Koen,

I tried this. Its working fine now. Thanks for giving guidance to me. Then, I have another doubt. Suppose if we create 2 sets of VM table, (First Receiver will act as 2nd one how do we achieve this). For Ex:

Set 1:

Source Agency: SYS1 Target Agency: SYS2

Source Scheme: CODE Scheme : DEPT

A HR

B Accts

C Finance

Set 2:

Source Agency: SYS2 Target Agency: SYS3

Source Scheme: DEPT Scheme : GRADE

HR Second

Accts First

Finance First

In this case, I followed the same logic which you said, but I am not able to create. I think the main point is GUID here. If you have any idea, kindly tell me.

Kind Regards,

Jegathees

[Former Member]

Jegathees,

This is as far as I know not possible. I would recommend creating a new Scheme for SYS2 (DEPT_2, for instance) and use that in the value mapping to SYS3.

Kind regards,

Koen

[jegathees_waran]

Hi Koen,

I am not able to save the first time of 'Austria' - 'AU' entry. ie. the problem. It allows only one-to-one mapping, that should be unique.So, till my problem is not solved.

[jegathees_waran]

Hi Vasu,

This is not the related link. I have gone through that.

[jegathees_waran]

Hi Barry,

Only one to one is working in Value Mapping Table in ID.

[jegathees_waran]

Hi Bary,

Only one to One is working in this VM. So, my requirement is not achieved.

[Former Member]

Hi Jegatheeswaran

Try doing it with FixValues instead of Value Mapping.

FixValues will not invoke this problem.

Hope this hepls

Regards

[Former Member]

Jeg,

Try the following:

After creating the entry for Australia - AU, save the value mapping and exit change mode.

Now double-click the Australia - AU entry.

This will take you toa screen which displays the same entry in a different format.

Here, enter Agency 'Computer1', Scheme 'Country' and value 'Austria'. Now, both Australia and Austria can be converted to AU.

The value mapping group will now have three lines:

Agency Scheme Value

Computer1 Country Austria

Computer1 Country Australia

Computer2 CountryCode AU

Kind regards,

Koen

[former_member529475]

HI Jeg

check the following thread.. might be useful ..

/people/sravya.talanki2/blog/2005/08/24/do-you-like-to-understand-147correlation148-in-xi

Cheers..

Vasu

[Former Member]

The logic is not sound.

You can map many to one, but not one to many.

Use AT (iso code) for Austria

[jegathees_waran]

Hi Bary,

Your said point is correct. I just misunderstand. Now, I am clear. Thank you for your good guidance.

Kind Regards,

Jeg P.