Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change and convert datatype in ODI for specific field before loading in target table

user12251389Oct 11 2021 — edited Oct 11 2021

Hallo All,
I am using ODI 12c and quiet new with this tool. I want to truncate and reload the target table from source but getting error as ORA-01861: literal does not match format string.
In my source table SRC_TBL i have column modtime which is of Varchar datatype. And the value in this field is something like '2011-02-25-08:47:43,731984'.
Before i load the data into target table TRG_TBL, i want to convert this modtime field to date and use below condition such that the value store in the TRG_TBL for field modtime will be '2011-02-25 08:47:43'
to_date(SUBSTR(modtime, 1, 19), 'YYYY-MM-DD-HH24:MI:SS') AS modtime
Can someone please help how to change this datatype in ODI and use above condition for field modtime. I dont want to use option CUSTOME_TEMPLATE in ODI where we have to write select query and override the logic of loading.

Below is my simple mapping:

This post has been answered by Marco Fris on Oct 20 2021
Jump to Answer

Comments

Srn87-Oracle

Hello,

    I am assuming you are trying to find out the costs of running oracle database on an AWS EC2 instance.

As far as i know,oracle database edition is free to use as long as it is used for non-production/non-commercial usages etc.Oracle licensing is not a straightforward topic and i doubt there is very little information in public domain on this.The licensing can be done based on many aspects,such as named users connecting to the db or based on db processors itself.Customer generally  has to work with Oracle sales to figure out a licensing plan that best suits their requirements.

Hence,I would suggest you to get in touch with your oracle sales representative who can give you the exact figures and conditions in terms of costing.

By the way,I think,running oracle on OCI could be far cheaper than running oracle on AWS EC2.

1 - 1

Post Details