0
on Source side :
Owner Name : SCOTT (Schema)
Source Table Name : Emp (table)
On Target Side :
Table Name Prefix : Scott(schema)
Target Table Name : DEPt (schema)
On Lookup :
Lookup table name needs to be changed.
Keep the OWNER name infront. ie
Example :
Lookup table name : SCOTT.LOCATIONS
Table looking priority if no owner name is provided
1) Under own schema
2) Public synonym.
0Awesome Comments!