Forum Stats

  • 3,815,479 Users
  • 2,259,036 Discussions
  • 7,893,119 Comments

Discussions

12C ODI : How to use ORACLE keyword(SIZE) in interface

3173245
3173245 Member Posts: 109 Green Ribbon
edited Feb 14, 2018 7:28AM in Data Integrator

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

Tagged:

Best Answer

Answers

This discussion has been closed.