This content has been marked as final. Show 4 replies
Could you provide the SQL code generated by ODI for this step ?
I guess that the lookup is doing a join with new syntax (ANSI) while you have old joins ( + ) done in your ODI joins.
There is two way to fix that :
* You can exit your lookup properties and select "SQL Expression in the select clause" instead of "SQL left-outer join in the from clause".
* Or, for each join in your canvas, click on it, then at the bottom of the property inspector, tick the "Use ordered join syntax" and assign a different number for each join. It will use the new syntax (ANSI).
I suggest you to check the generated code before/after each change so you can understand the differences.
Hope it helps.