TOS DI 6.3.1 : problem with timestamp

Four Stars

TOS DI 6.3.1 : problem with timestamp

Hello to all,  i have a problem with a copy of timestamp which truncates nanoseconds (,000000001 becomes ,000000000).    

Do you have an idea on this issue ? 

My data provide from Oracle 11g databases and I use TOS DI 6.3.1 (free tool).

 

Thanks in advance, 

Best regards,

Bertrand

 

Fifteen Stars TRF
Fifteen Stars

Re: TOS DI 6.3.1 : problem with timestamp

Hi,

 

Can you give a little bit more details?

What datatype are you using to store these timestamps?

Which components are using?

Do you know the step in which the truncation occurs?


TRF
Four Stars

Re: TOS DI 6.3.1 : problem with timestamp

More details  : 

I copy the same table between 2 Oracle databases : I use tOracleInput and tOracleOutput components. The 2 tables have the same structure. IN the Tmap, timestamps have date structure.

 

In my imput table I Have a Timestamp(9)  ; examples :    25/05/17 15:05:06,000000001     to      25/05/17 15:05:06,000000143

 

After my copy, the result is :  25/05/17 15:05:06,000000000    for all the lines in the output table. In fact , I lose the precision for the nanoseconds.

 

 

 

 

 

 

 

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now