9.13.2012

Value Cross vs ID Cross Referencing

Difference between Value and ID Cross references in BizTalk Server

(OR) 

Difference between Value Cross Referencing and ID Cross Referencing in BizTalk Server


S.No
Value Cross Referencing
ID Cross Referencing
1
Whether it can be modified during runtime:
These cannot me modified during run-time.
Whether it can be modified during runtime: 
These may be set at run-time. Set Common ID functoid is used for this.
2
Where it occurs ?
This occurs between app types.

Where it occurs ?
This occurs between appinstance types.
3
 Where it occurs normally ?
This cross-referencing commonly occurs between enumeration fields.
Where it occurs normally ?
This cross-referencing commonly occurs between entity unique identifiers.
4
Caching Mechanism is used or not:
This uses caching mechanism. After any changes in database, we have to restart the corresponding host instances to see the changes.
Caching Mechanism is used or not:
In this, we will hit the database for every call.
5
What kind of mapping is used ?
It’s a many-to-one mapping.
What kind of mapping is used ? 
It’s a one-to-one mapping.
6
Mapping Direction - Unidirectional or Bidirectional ?
The mapping is gauranteed in only one direction.
Mapping Direction - Unidirectional or Bidirectional ?  
The mapping is gauranteed in both directions.
7
Value Cross Referencing behaviour while using Reverse Mapping:
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.
ID Cross Referencing behaviour while using Reverse Mapping:
Reverse mapping is always in synch with the initial mapping.
8
Following mapping is allowed or not?
Apple – Fruit
Banana – Fruit
Grape – Fruit
The above mapping is allowed. So in this case , the reverse mapping may not give the expected output.
Following mapping is allowed or not? 
Apple – Fruit
Banana – Fruit
Grape – Fruit
The above mapping is not allowed allowed and are restricted by constraints on the Id cross reference tables.
9
What functoids need to be used in the maps ?
We have to use the GetCommonValue & GetApplicationValue functoids in the maps
What functoids need to be used in the maps ? 
We have to use the GetCommonId & GetApplicationId functoids in the maps

No comments:

Post a Comment