This content has been marked as final. Show 4 replies
Hi RG,1 person found this helpful
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.
Thanks for your reply,
Actually I went into topology-->oracle--> properties there In SQL tab Under "not ordered" ,value for "outer keyword" was "(+)"
I first removed it, then it was adding word "NULL" after each join so getting error.
then I changed it to 1=1, Now I am OK.
Glad you sorted it out.
Is your problem with CLOB resolved ?
Don't forget to mark this question as resolved for future reader ;).
No, I still have issue with CLOB one.