value mapping replication

[Former Member]

Hi,

I was following these two links for the value mapping replication.

/people/sreekanth.babu2/blog/2005/02/23/value-mapping-replication

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e07dd2ae-f783-2c10-9aa6-ca69f67dd...

My requirement is to read a csv file that has two fields and I will have to push this data to PI run time cache and access it through mapping replication in my actual mapping that sends the file out to a business partner. Now my question is how do I push the data to the run time cache ? Should I always have a seperate mapping which has the two fields (that are on the file) inside a datatype / message type on my sender side and the receiver side, the message type should be a ValueMappingReplication standard asynchronous interface ? or the ESR mapping configuration is not necessary at all?

If thats not necessary, I did the steps based on the second link and does that mean if I place the file and allow PI to read the file, the data will be automatically pushed to run time cache ?

If its necessary, what do I map my payload to ? I will have two fields inside my message type that are empID and Indicator on the sender side and on the receiver side, I will have ValueMappingReplication message type. I am not sure how to map my pauload. If there is any document that tells me how to do the mapping, that will be great.

V

[Former Member]

hi,

You need to map to the valueMappingReplication data type.

In there if you want to have a query returning more than 1 value you need to put them all under the same group id.

so your input is empId, indicator for each pair you should map it like this

<ns1:ValueMappingReplication xmlns:ns1="http://sap.com/xi/XI/System" xmlns:xsi="http://www.w3.org/2001/XMLSchemainstance">
	<Item>
		<Operation>Insert</Operation>
		<GroupID>fe9ffaa0494211dea47b001e372d2d65</GroupID>
		<Context><a href="http://some/namespace" TARGET="test_blank">http://some/namespace</a></Context>
		<Identifier scheme="VALMAP" agency="empID">empIDvalue</Identifier>
	</Item>
	<Item>
		<Operation>Insert</Operation>
		<GroupID>fe9ffaa0494211dea47b001e372d2d65</GroupID>
		<Context><a href="http://some/namespace" TARGET="test_blank">http://some/namespace</a></Context>
		<Identifier scheme="VALMAP" agency="indicator">indicatorValue</Identifier>
	</Item>
</ns1:ValueMappingReplication>

note that the GroupID is the same for elements that you want to have grouped. then in your value mapping you can use the source agency as empID and target agency as indicator and you will have a value map from empID to indicator

[stefan_grube]

This blog shows how the value mapping structure has to be filled:

/people/udo.martens/blog/2009/04/03/value-mapping-replication-scenario

When you have a file, you need to map the data to the structure.

You need a user-defined function in mapping to generate a GUID.