Synonym Reverse Engineering
237437Jan 1 2009 — edited Oct 13 2009Hello All,
Wish you all a Happy New Year.
I have two schemas by name
1) ABC
I have a table by name "Employee" in the "ABC" Schema.
2) DEF
I have created Synonym using the following command in the "DEF" Schema
Create public synonym STST_EMPLOYEE_TBL for ABC.EMPLOYEE.
When I reverse engineer the MODEL (by selecting SYNONYM check box) created using PHYSICAL/LOGICAL Schema of "DEF". It reverse engineers without any errors. But when you expand the Columns of the SYNONYM in the model, it does not show any COLUMNS at all.
Kindly let me know whether it is the limitation in ODI or my mistake.
Thanks
Edited by: cdmnagaraj on Jan 1, 2009 4:06 AM