SIM025: Import Specifications and Data Loads

Duration:	Two Days
Attendees:	Maximum two people.
Pre-requisites:	CIS101 and proficiency in data using MS Access or other local database.
Where:	On site at your premises or at Simplicity Training Centre Auckland
Cost:	On Site Australia or NZ $2,400 per person minimum 2, At Simplicity Training Centre $1,800 per person minimum 2, Webex $2,400 per person minimum 2.
What you can expect to learn:	Field mapping,, create relationships between entities, record matching and import bulk groups of data into Simplicity Database.

Overview of Entities
Understanding RSNs
Import Specification
Creating a new import specification
- Understanding source data
- File types for importing
- Mapping source data to fields in data base
- Using functions and conditional rules to manipulate source data
- Creating relationships between entities
- Creating campaign activity records
- Importing data into entity specific data load tables.
Data Load Tables
- Understanding different entity tables
- Understanding Record Status
- Defining and running Matching Rules
- Understanding processing order
- Processing data load records
Event Logs and checking loaded data
Execution Plans
- Create plan to match and process data load tables
- Automating execution plans

SIM 025: Import Specifications and Data Loads