I've extracting data from oracle and storing into csv file.
There is one date column field where date comes in this format "01-12-2017 21:51:42"
But what happens some time while extraction data in csv files date comes like this "2017-12-01 21:51:42", so my further process gets failed. But when I do extraction again it comes fine with this format "01-12-2017 21:51:42".
Mat I know please what could be reason for this fluctuation ? I always check the DB when I get wrong date format in csv but in DB it always shows the correct only "01-12-2017 21:51:42".
I suggest you to include a date format for those queries such as:
TO_CHAR(yourDateColumn, 'DD-MMYYYY HH24:MI:SS')
This will ensure the output format.
After extraction are you openning csv file ? to avoid this kind of issue please open in Notepad++.
I can't use your logic because am using dynamic schema. I'm loading multiple tables one by one and in every table date column name is different.
I'm using multi-threading, Do you think so it could be the issue...?
Can you post your job design here?
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