Hi again,
Three days ago I asked about the problem with datatypes of datastores in models which were missing. After applying of ideas suggested by Mahak (many thanks ) I got them working.
But after that we came upon a new problem. When executing a mapping (Oracle to Oracle databases), it failed on the second step - ""Create work table"". When we checked the generated code it was something like that: ""CREATE TABLE <work_table_name> ()"". No column names or datatypes were described in brackets and as expected the ODI error of the execution was "invalid identifier". It seems that API odiRef.getColList(params)%> does not work. I tried loading using LKM Oracle to Oracle (DB LINK) but again columns are missing in generated script.
I have to mention the master and work repositories are on different Oracle databases and ODI Agent is not still installed because of some problems.
We are still newbies in ODI and would appreciate any help from more experienced guys (or other newbies).
Thank you in advance.