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,
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?
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.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Learn how and why companies are moving to the Cloud