As I’m learning Data Migration Manager I have created a few projects. For a couple of them, while Mapping Legacy Tables to Migration Object there has not been any Target Tables available in the Smart Mapping assistant and I have had a hard time figuring out why. Am I missing any setup? What are the requirements for Target Tables to be available for Smart Mapping?
Page 1 / 1
Hi @Addomaby , Please make sure you have these.
You need to have any target tables connected with the migration object which you have on your Mapping Legacy Tables to Migration Object.
you need to have the legacy table with lock load here.
If you have these configured on your project setup, then you can be able to do the mapping on the smart mapping
It is connected to a Migration Object and still not available to select.
Mak sure you have your target table as in scope on your project basic data setup
Target Table is in scope and Target Table Definition is Created.
The connected Migration Object is also In Scope and Used in Mapping
Hi @Addomaby
I assume you already refreshed the browser cache?
Can you please provide some screenshots of your current setup and the name of the target table which will not be shown?
So e.g.
Within the migraiton object the “Migration Object Details”:
As I have added no “Legacy Tables with locked loads” in the previous screen there will be of course no “Locked Legacy Table Names” as seen in your screenshot but I can select my target table.
/Jens
Hi @Jens
I had not tried refreshing the cache previously and tried now without any change.
This is my corresponding setup.
In the last image, the table was not to be found in the Target Table drop down either.
Hi @Addomaby
possibly the creation of the “migration object”, the “mapping legacy tables to migration object”, the connection of the target table to the “migration object”, the creation of the target table definition and setting the scope was not done in the right order.
Without using a DMM project template
Create a migration object (in scope)
Add a target table (in scope) and connect it to the migration object
Create the target table definition
Load a legacy file (I ignored this step for this example as already mentioned)
Perform “Mapping legacy tables to migration object”
Add the “Legacy tables with lock load” (I ignored this step for this example as already mentioned)
Perform the mapping
I assume you performed the steps without number 2 and/or 3 and these steps you performed afterwards. I’m only thinking loud.
You can try the following now please:
Go to the “Mapping legacy tables to migration object” screen and now press the button “Mapping Detail sOptions]”.
Here execute “Resync Mapping Target Fields”.
Is your target table CUSTOMER_INFO now visible and available for the mapping?
This functionality fetches all target tables in scope (with created target table definitions) related to the selected migration object and also perform changes related to the target table definitions (important if you have for example new fields in your target table which didn’t exist in the previous mapping - but then you you also have to perform “Extract Meta Data” in the target table definition to get “new/modified/removed” fields).
So if you would already have one target table for one migration object in the mapping available and now you add a 2nd one then you also have to use this functionality to see your 2nd target table.
/Jens
Go to the “Mapping legacy tables to migration object” screen and now press the button “Mapping Detail DOptions]”.
Here execute “Resync Mapping Target Fields”.
This functionality fetches all target tables in scope (with created target table definitions) related to the selected migration object and also perform changes related to the target table definitions (important if you have for example new fields in your target table which didn’t exist in the previous mapping - but then you you also have to perform “Extract Meta Data” in the target table definition to get “new/modified/removed” fields).
So if you would already have one target table for one migration object in the mapping available and now you add a 2nd one then you also have to use this functionality to see your 2nd target table.