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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables