Are you saying that you will have two tables in your staging area database and you want to configure the UDA in FDMEE to point to those tables?
Or are you saying your two UDA configurations will point to different source systems and tables?
Yes, two tables in the Staging Area Database and want to know if a single UDA would work or we need to have separate ones
You should be able to copy the existing source adaptor to a new adaptor key and then enter a new table name, then import table defintion and generate template package and so on.
1 person found this helpful
So the error is linked to your previous post which was about a single UDA configuration - FDMEE Export error using Oracle UDA
So are you saying it is not even working for a single UDA configuration, if the table cannot be found and exists then I assume that either the configuration is incorrect, either the user that is executing does not have rights, or it is being executed against the incorrect logical schema. Like I said in the other post, ditch the ODI console when configuring the UDA and use the ODI Studio and then follow the blogs, docs that are available as it does work.
I was able to fix this by mapping the AIF_TGT to the right Physical Schema from the backend. Thanks for your help!