Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Technical Consultant - Apps10 > Data Migration > Flashcards

Data Migration Flashcards

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

A

New, Modify

24
Q

Data migration approach

A

Package interface

25
Q

Replication out XML structure record hierarchy control

A

Map parent view (parent sequence)

Sequence of master view

26
Q

Auto generated code squence replication?

A

Automatic

27
Q

Replication migration job types/modes

A

Manual, Automatic, Batch

28
Q

EXCEL_MIGRATION creation initial steps

A

Add view names and method list BEFORE saving header

29
Q

CREATE_OUTPUT_FILE view join process

A

Comma separated Source Names, Join condition in Where

Source names can be aliased as necessary

30
Q

CREATE_OUTPUT_FILE view exclusion step

A

Set Pos = 0

31
Q

Minimum pre-requisites for OnServer file location

A

Oracle directory created, relevant users granted access

Technical Consultant - Apps10 (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions