Wednesday, 27 March 2013

Samples for Biztalk Mapping Types( One to One and One to Many)

This blog is helpful for BizTalk maps beginners. I would like to start my blog with types of mapping scenarios. For every mapping we first think about the type of mapping. Mappings are categorized into two:
1.       Simple Mapping
2.       Complex Mapping
Simple Mapping:
                For beginners, it is better to start with Simple Mapping. The Source and Destination elements have One-to-One relationship. We can either directly map the elements or apply many types of transformations and translations using multiple Functoids depending on the requirement.
Complex Mapping:
                Complex Mapping involves the elements with One-to-Many, Many-to-One and Many-to-Many relationships. Before starting the complex mapping, it is better to see the properties of source and destination elements that you would like to map. Why because, most of the times complex mapping fails due to property values.

I would like to show samples separately for different mapping scenarios by using Employee details.

Source Schema:

Destination Schema: