Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm new to Talend I have no idea about datetime to timestamp conversion I tried changing date pattern in expression column for the target table in tmap, no error and migration worked fine but then no date value stored in the new column for date (because it's a timestamp db type) it's all null, is there any way I can do to solve this?
Thanks!
Here's what I have:
Is the 'Use Timestamp for Data Type' causing it to fail entering the output db?
You could try unticking that.
How do you know that the data is not getting to the target database? Are you able to query the target database? The problem I have with what you are telling me is that you are saying that data is being sent, but the date is not arriving, yet there are no errors at all. This suggests that either the column is being supplied as null or that maybe the date column you are checking is not the correct one.
When you run the job, can you put a tlogrow between the tMap and the Oracle component and ensure the tLogRow is configured to Mode=Vertical. This will tell you the name of each column and the value each holds. Then check your database, find the row and check every column in the row.