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

 

  • Data Integration
Tags (1)
2 REPLIES
Seven Stars TRF
Seven 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.