Technical Articles
How to do a pre-selection of records in the direct approach: Migration Cockpit 2020
Hello guys,
Or you can use the functionality “Mass Processing”
However, this can be very slow in the process. So I recommend you to do this in the migration object in the backend. This tutorial will teach you how to do it in LTMOM.
Requirements
Direct transfer project with the object you want to filter created.
Scenario
Let’s suppose that you want to load in the target only the Master Banks information with Country Key “DK” using direct approach transfer with Migration Cockpit.
Tutorial
This example is done for Master Bank object:
Go to the transaction LTMOM in the backend:
Choose your project where you have your Migration Object to be migrated:
Choose the object to filter.
Go to source tables and select the root node. Select the field to filter. Put the migration object in the change mode (ctrl +F1)
If you select more than one value to filter, after executing, it will appear just the first value but don’t worry; all values are selected.
The fields with filters will have the select checkbox black.
Save and put the object in the display mode again (ctrl + F1)
Go to the Migration Cockpit
Choose your project
Click select data
Start the selection
The activities running will increase.
You can check if the selection is right by clicking in “Instances” (even during the selection running):
After the running activity is finished, you can proceed with the mapping.
And that is it!.
Let me know if you have any questions or comments about the content.
Dear Sarah,
I have defined selection criteria in my migration project for Direct Transfer of Purchase Info Records by LTMOM as described in your Blog. I defined filter values for the field EINE-WERKS and the according preselection table /1LT/OTP00000506 was filled in the source system.
Then I found out that data is missing and I changed the filter for EINE-WERKS to select also records where the field EINE-WERKS is empty.
But when I redo the data selection in the migration cockpit the preselection table is not updated.
How can I refresh the preselection table after change of filter criteria?
Answer: I removed filter logic "WERKS" and left only the relevant values in the select option "Additional selection criteria". Then the preselaction table was updated.