Thursday, 4 December 2014

Synonym Reverse Engineering in ODI

In ODI synonym can be reverse engineered by two possible ways such as 
Standard , Custom Option .

Standard :
Columns won't get reverse engineered if we use Standard Option . For that we need to follow the following step :

Open your Data Server where you want to create Synonyms go to properties tab and add a new key,

key=includeSynonyms and value = true




Public synonyms never be reverse engineered using standard Option 

Custom:
Select the suitable RKM according to source system. For example for Oracle source , RKM oracle .
 




No comments:

Post a Comment