Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to updating mapping table automatically

886365Sep 15 2013 — edited Sep 18 2013

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.

Comments

JeffJon


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).    

1 person found this helpful
Thanos A

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

1 person found this helpful
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 16 2013
Added on Sep 15 2013
#business-intelligence-applications, #financial-data-management, #performance-management-applications
2 comments
367 views