Data Migration Flashcards
Source Migration sources
DB link, multiple tables or views (Union, Join)
Also text files, Excel add-in
External Replication usual message type
BizAPI
SKIPLINES migration rule result
Skips the top qty of rows specified
External Replication procedure name
REPLIC_DATA_OUT
Created manually from Replication Structure
“Rebuild Mappings” in Data Migration Excel Add-in purpose
Synchronize column changes
Data Migration Excel add-in permission set
FNDMIG_EXCEL_ADDIN
File Migration purpose
Transfer data to or from database and files
Data Source Designer data source types
SQL, Query Builder, Cube, Information Source
Data Migration procedure to load external data into two or more LUs
MIGRATE_SOURCE_DATA
Data Migration procedure Logical Unit
IntfaceUtil
Data Migration Basic Data - User
Lists users with privilege level
NoUpdateAllowed or UpdateAllowed
Data Migration Basic Data - Pr User
Lists users with migration jobs
Action to temporarily exclude method execution
NoExecution
Method List on Migration Job
Data Migration types
File, Source, Excel, Export/Import, Replication
Source Migration purpose
Migrate data from one data source to another
Replication Migration purpose
Replicate data within app instance, or replicate to external system
using Connect/BizAPIs
Excel Migration purpose
Migrate data between Excel and the database using add-in
Export/Import Migration purpose
Export/Import jobs between app instances
Data Migration tool definition
Loads data from external sources into application core objects
Data Migration typical use
Move data from legacy systems upon implementation
Logical unit, table, and view structure
LU = X, View = X, Table = X_TAB
Data Migration procedure notes
some are pre-packaged, custom procedures can be developed
Data migration LU interface methods
New, Modify
Data migration approach
Package interface
Replication out XML structure record hierarchy control
Map parent view (parent sequence)
Sequence of master view
Auto generated code squence replication?
Automatic
Replication migration job types/modes
Manual, Automatic, Batch
EXCEL_MIGRATION creation initial steps
Add view names and method list BEFORE saving header
CREATE_OUTPUT_FILE view join process
Comma separated Source Names, Join condition in Where
Source names can be aliased as necessary
CREATE_OUTPUT_FILE view exclusion step
Set Pos = 0
Minimum pre-requisites for OnServer file location
Oracle directory created, relevant users granted access
