Person Destination

Example entity for the data mapper and merger functionality

Package Logical datamodel example
Author Bert Dingemans
Alias --
Stereotypes --

Attributes

Name Type Cardinality Description
BusinessEntityID String 1 - 1Primary key for Person records.
PersonType String 1 - 1Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact
NameStyle Boolean 1 - 10 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
Title String 1 - 1A courtesy title. For example, Mr. or Ms.
FullName String 1 - 1First name of the person.
Suffix String 1 - 1Surname suffix. For example, Sr. or Jr.
EmailPromotion String 1 - 10 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.
AdditionalContactInfo String 1 - 1Additional contact information about the person stored in xml format.
Demographics String 1 - 1Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
rowguid String 1 - 1ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate String 1 - 1Date and time the record was last updated.

Mappings

NameSourceSource attributeTargetTarget attribute
AdditionalContactInfo Person DestinationAdditionalContactInfoPersonAdditionalContactInfo
BusinessEntityID Person DestinationBusinessEntityIDPersonBusinessEntityID
Demographics Person DestinationDemographicsPersonDemographics
EmailPromotion Person DestinationEmailPromotionPersonEmailPromotion
NameStyle Person DestinationNameStylePersonNameStyle
PersonType Person DestinationPersonTypePersonPersonType
FullName Merger FullNameFullNamePerson DestinationFullName

Diagrams

Data Mapper and Merger example

--

Linked elements

Logical datamodel example