Table Length Issue in ODI
Hi There,
I have an issue while running an interface in ODI 11g.
There is a step in my interface where it creates unique index.
It usually takes the table name and prefixes with 'I$_' and suffix with '_x'
Example of my index is *'I$_Tablename_x'* if the table name is 30 charcaters then the index name will be 35 charcters which is not allowed in oracle . Hence giving an error in interface.
So i Went to topolgoy -> physical architecture -> oracle -> others and changed the table name and column name length to 25.
However when i run the interface again the table name is getting stripped to 25 charcters hence giving an error "ORA-00942: table or view does not exist" which makes sense.
Please help me to overcome this issue.
Thanks,
Babu.