Data Migration Flashcards

(31 cards)

1
Q

Source Migration sources

A

DB link, multiple tables or views (Union, Join)

Also text files, Excel add-in

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

External Replication usual message type

A

BizAPI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

SKIPLINES migration rule result

A

Skips the top qty of rows specified

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

External Replication procedure name

A

REPLIC_DATA_OUT

Created manually from Replication Structure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

“Rebuild Mappings” in Data Migration Excel Add-in purpose

A

Synchronize column changes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Data Migration Excel add-in permission set

A

FNDMIG_EXCEL_ADDIN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

File Migration purpose

A

Transfer data to or from database and files

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Data Source Designer data source types

A

SQL, Query Builder, Cube, Information Source

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Data Migration procedure to load external data into two or more LUs

A

MIGRATE_SOURCE_DATA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Data Migration procedure Logical Unit

A

IntfaceUtil

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Data Migration Basic Data - User

A

Lists users with privilege level

NoUpdateAllowed or UpdateAllowed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Data Migration Basic Data - Pr User

A

Lists users with migration jobs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Action to temporarily exclude method execution

A

NoExecution

Method List on Migration Job

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Data Migration types

A

File, Source, Excel, Export/Import, Replication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Source Migration purpose

A

Migrate data from one data source to another

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Replication Migration purpose

A

Replicate data within app instance, or replicate to external system

using Connect/BizAPIs

17
Q

Excel Migration purpose

A

Migrate data between Excel and the database using add-in

18
Q

Export/Import Migration purpose

A

Export/Import jobs between app instances

19
Q

Data Migration tool definition

A

Loads data from external sources into application core objects

20
Q

Data Migration typical use

A

Move data from legacy systems upon implementation

21
Q

Logical unit, table, and view structure

A

LU = X, View = X, Table = X_TAB

22
Q

Data Migration procedure notes

A

some are pre-packaged, custom procedures can be developed

23
Q

Data migration LU interface methods

24
Q

Data migration approach

A

Package interface

25
Replication out XML structure record hierarchy control
Map parent view (parent sequence) | Sequence of master view
26
Auto generated code squence replication?
Automatic
27
Replication migration job types/modes
Manual, Automatic, Batch
28
EXCEL_MIGRATION creation initial steps
Add view names and method list BEFORE saving header
29
CREATE_OUTPUT_FILE view join process
Comma separated Source Names, Join condition in Where | Source names can be aliased as necessary
30
CREATE_OUTPUT_FILE view exclusion step
Set Pos = 0
31
Minimum pre-requisites for OnServer file location
Oracle directory created, relevant users granted access