Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
12C ODI : How to use ORACLE keyword(SIZE) in interface

Hi Experts,
For one the interface, we have source as SQL SERVER and target as ORACLE.
In SQL SERVER View, there is an column name SIZE.
When we are using same name SIZE in interface, while creating $ tables (staging table ) at run time Interface is failing as SIZE is an KEYWORD in ORACLE.
i have tried by adding quotes (") like "SIZE" at Model, by this $ tables are creating successful but while loading data from SQL SERVER to $ table interface is failing like "SIZE" column not available at SQL SERVER view.
could any once can know any alternate way to use this SIZE column in ODI 12C interface??
Thanks
Phani
Best Answer
-
Hi,
you can use LTRIM and RTRIM they both are applicable to oracle and SQL server
Answers
-
Hi Phani @3173245 ,
You may create a new MS SQL Server view in your source side where you don't have Oracle reserved words simply for the column names. If you don't want to do this then you need to copy, modify and use the newly changed LKM. You mainly need to change the "<%=odiRef.getColList." part. Please take a look at the following thread:
ODI 12c Mapping, dealing with reserved words on different SRC and TRG datasources
Regards,
Aramast
-
Hi,
You can also follow note: Reserved Words Still Causing Problems After Patch 20561136 is Applied in ODI 12c (Doc ID 2068571.1)
Adrian
-
Hi Aramast,
I have some TRIM,SUBSTR's used at interface.
when i'm replacing [EXPRESSION] to [[COL_HEADING]] , then TRIM and SUBSTR's are not present in back-end QUERY.
<%=odiRef.getColList(i, "", "[EXPRESSION]\t[ALIAS_SEP] [CX_COL_NAME]", ",\n\t", "", "")%>
to:
<%=odiRef.getColList(i, "", "[[COL_HEADING]]\t[ALIAS_SEP] [[CX_COL_NAME]]", ",\n\t", "", "")%>
could you please help in this.
Thanks
Phani
-
-
Hi,
Try to follow the note I have recommend because it is the best approach. You have just to install a patch and configure the reserved keyword.
Adrian
-
Hi,
can you put some expression in between and try renaming the column there. can make sure that Expression Unit runs on Sql server itself.
Thanks
-
Thanks for the info.
i can't install any patch directly ,as it involves many approvals from business.
ThnakS
-
we can't execute expressions at SQL SERVER as some of the expressions like TRIM cant be executed on SQL SERVER .
Thanks
-
Hi,
you can use LTRIM and RTRIM they both are applicable to oracle and SQL server