Monday, 23 January 2017

Handling Schema Names in Source and Target of Informatica

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.

No comments:

Post a Comment