BizTalk Server Tutorial

BizTalk Server Concepts and Common Errors

Difference between Value & Id Cross references

I spent some time to know the differences between “id” and “value” cross referencing and I was able to get the below points which I thought of worth sharing.

At a high level, these two concepts will look similar. But they operate with few differences.
Here are those.

S.No

Value Cross Referencing

Id Cross Referencing

1

These cannot me modified during run-time.

These may be set at run-time. Set Common ID functoid is used for this.

2

This occurs  between app types.

This occurs between appinstance types.

3

This cross-referencing is commonly between enumeration fields.

This cross-referencing is commonly between entity unique identifiers.

4

This uses caching mechanism. After any changes in database, we have to restart the corresponding host instances to see the changes.

In this, we will hit the database for every call.

5

It’s a many-to-one mapping.

It’s a one-to-one mapping.

6

The mapping is gauranteed in only one direction.

The mapping is gauranteed in both directions.

7

When you want to use them for the reverse mapping for a value which is mapped to multiple inputs, the first value stored in the xref tables is fetched.

Reverse mapping is always in synch with the initial mapping.

8

Apple – Fruit
Banana – Fruit
Grape – Fruit
The above mapping is allowed. So in this case , the reverse mapping may not give the expected output.

Apple – Fruit
Banana – Fruit
Grape – Fruit
The above mapping is not allowed allowed and are restricted by constarints on the Id cross refernce tables.

9

We have to use the GetCommonValue & GetApplicationValue functoids in the maps

We have to use the GetCommonId & GetApplicationId functoids in the maps

September 3, 2011 - Posted by | Maps | , , , , , , , ,

1 Comment »

  1. […] To get the differences between these 2 concepts further refer my another post. […]

    Pingback by Cross Reference Functoids in BizTalk Server « BizTalk Server Tutorial | September 3, 2011 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: