How to transfer the data from import set table to target table?

[swathigangadhar]

How to transfer the data from import set table to target table?

1. I have created rest message and calling rest message from scheduled job, when it get executed data will be stored in import set table.... and i had created transform map also, and mapped the import set table and target table.... But when i click on transform, it is not happening... How to run transform?

[anurag92]

Did you check Transform history/logs to find whats the error for not updating in Target table?

[harishdasari]

Hi Swathi,

Just have a doubt to ask, did you map the fields in transform map using auto mapping or mapping assist before you transform into the target table ?

thanks

[georgimavrodiev]

Hello Swathi,

Once you create the transform map and make the connection between the source and target tables - you need to use the Auto Map Matching Fields, located under the Related Links. Once the Field maps are created, click on Mapping Assist. There, you will have to manually select each item from the Source table and match it with the respective one from the Target table. Have in mind that there is a possibility that some of the items (fields of the Target table) will be left without a match. It depends on the fields of the Source table.

After you finish with the matching - press the Transform button located under the Related Links. You will be directed to Specify Import set and Transform map form. Click the Transform button again.

This should do the trick and you should be able to achieve your goal.
If it does not work, then go back and perform the steps from the begging.

Best Regards,
Georgi Mavrodiev

IT Consultant
Do IT Wise

You may visit us in our Web Site: www.doitwise.com

[swathigangadhar]

Yes, i have done mapping between two tables, when i press transform am getting the above error....