I am facing an issue where the IICS mapping loads incorrect date value to Amazon Redshift DATE column. The date value is always loaded as one day lesser in Amazon Redshift.
For example, if the date in source is 1 Feb 2020, without any transformation, the date will be loaded automatically as 31 Jan 2020.
By checking the staging file and session log (by turning on verbose data mode), the date is shown correctly, which is 1 Feb 2020.
Does anyone know how to fix the date value minus one issue?
Note: If DML statement (simple insert query) is put at POST-SQL session in IICS mapping, the date is inserted into Redshift table correctly though.
Retrieving data ...