Interactory Publicaties
Home
Onderwerpen
IDEA Addon voor Sparx
Web Publicatie Platform voor Sparx
Architectuur Repository
Sparx Enterprise Architect
Architectuur
Webvideo's
Whitepapers
Blog
Alle onderwerpen
Zoeken in repository
Trefwoorden zoeken in repository
ArchiMate zoeken in repository
Geavanceerd zoeken in repository
Packages in repository
Diagrammen in repository
Repository elementen
Extra
Repository verkenner
Matrix van Package
Matrix van Diagram
Begrippenlijst
Grafieken
Release notes
Participant
Inschrijven voor de webmailing
Login
Contact
Deze website is verplaatst naar
Data-docent.nl
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 - 1
Primary key for Person records.
PersonType
String
1 - 1
Primary 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 - 1
0 = 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 - 1
A courtesy title. For example, Mr. or Ms.
FullName
String
1 - 1
First name of the person.
Suffix
String
1 - 1
Surname suffix. For example, Sr. or Jr.
EmailPromotion
String
1 - 1
0 = 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 - 1
Additional contact information about the person stored in xml format.
Demographics
String
1 - 1
Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
rowguid
String
1 - 1
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate
String
1 - 1
Date and time the record was last updated.
Mappings
Name
Source
Source attribute
Target
Target attribute
AdditionalContactInfo
Person Destination
AdditionalContactInfo
Person
AdditionalContactInfo
BusinessEntityID
Person Destination
BusinessEntityID
Person
BusinessEntityID
Demographics
Person Destination
Demographics
Person
Demographics
EmailPromotion
Person Destination
EmailPromotion
Person
EmailPromotion
NameStyle
Person Destination
NameStyle
Person
NameStyle
PersonType
Person Destination
PersonType
Person
PersonType
FullName
Merger FullName
FullName
Person Destination
FullName
Diagrams
Data Mapper and Merger example
--
Gekoppelde elementen
Logical datamodel example
Person
Merger FullName
Links 2 Tags
Archimate
Architect
Architectuur
Architectuur document
Architectuur repository
Big data
Bouwblokken en patronen
Criteria
Data
Data architectuur
Data governance
Data kwaliteit
Data management
Data modelleren
Enterprise architectuur
Idea
Image library
Master data
Matrix
Mdg
Meta data
Metafoor
Modelleren
Open source
Principes
Register
Repository
Simulator
Software
Sparx enterprise architect
Sql
Stakeholders
Time aware modelleren
Tips en tricks
Training
Webvideo
Wpp