Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data - Coggle Diagram
Data
Data Model
Standard object
Sale
service
Survey
FSL
CPQ
Consent
Custom object
External object
Relation
MD
Lookup
Owners
Master and transaction objects.
Record type
Data Migration
Source system
ETL
staging
Cleanse
Dedup
Enrich
canonical schema
Best practiecs
Defered sharing
Switch off automation
Bathc process for post processing
ETL performnig some automations
switch of VR
Group by parent id
Link external id
Seq of migration
Delta approach!!
Automation of Dedup and cleansing job
Bupass automation/triggers for the bath job user.
upsert on the existing records
Data Validation
Report
Spot checks
Functional testing on migrated data
Sequence of steps
Create role hierachy
Migrate users
Enable updating audit data
Knowledhe migration via import
LDV
query optimiser
selective query
using Group by rollup to test selectivity
std index
id
name
ownerid
lookup/MD
Record type
External id
Auto numner
text
email
number
30% of 1M+15% rest or max 1M
custom index
10% of 1M+5% of rest , max 333333
Not on not deterministic formula
skinny tables
LACOC and custom object
max 100 column from one table
copied to full sandbox only
Delete records
use isDeleted flag
Bulk API to hard delete
in Recycle bin for 15 days
Division
Aggregate data(scenario based)
Data archival
DWH
Heroku
App exchange - Odaseva
MDM