Date data type changes to string in the import set table

[Bindhu1]

I'm loading data from SQL, which includes a date field called 'EOL'. After loading the data into the staging table, it's being stored as a string. Because of this, the 'EOL' value from the source isn't mapping correctly to the target 'EOL' field, which is of date type.

Any help ?

[Anantha Gowrara · Accepted solution]

@Bindhu1 by default all fields under staging table will be created as string hence you must change the field value to date. If system is not allowing to update field type then delete that field in staging table and manually create one with same name and type as date.