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 

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

1 comment: