Hi,
I reverse engineered some tables from postgresql db and create a simple mapping. But the mapping failed. From the ODI generated code, I can see that there is a dot "." is placed in front of the table names right after the "From" keyword. I believe that is what cause the mapping failed. Such as: " .mi_user", and ".mi_device".
And when I tried to view the data from data stores, the same error come up as the error message on mapping failure. Is there any workaround to get rid of the ".". Thank you for your help!
Generated Code Snippet Here:
|
FROM .mi_device AS MI_DEVICE INNER JOIN (.mi_user AS MI_USER INNER JOIN .mi_device_ios AS MI_DEVICE_IOS ON MI_USER.device_id = MI_DEVICE_IOS.device_id ) ON MI_DEVICE.device_id = MI_DEVICE_IOS.device_id
|
