How to updating mapping table automatically

886365 Sep 16, 2013 3:47 AM

Hi everyone,

Can anyone please tell me how can we update the mapping table automatically.....? We get the mapping table file in .csv format (2 fields, one is source, other is target) to our server.

The requirement is to update the mapping table automatically, when the file is present in local disk ( I mean to say particular location/path in system/server).

Thanks in advance,

James.

1. Re: How to updating mapping table automatically

JeffJon Sep 17, 2013 7:17 PM (in response to 886365)

There is not an out of the box functionality to perform this operation.

it would need to be something custom to run the import of the .csv file into the mapping table (tdatamap).
Like Show 1 Likes(1)

Actions
2. Re: How to updating mapping table automatically

Thanos A. Sep 18, 2013 9:43 AM (in response to 886365)

Hi there,

You can write a script that will be executed when you will load the text file.

You can check the FDM_admin manual who to write scripts in workbench.

Regards,

Thanos
Like Show 1 Likes(1)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.