Skip to Content
-1
Jul 01, 2020 at 07:06 AM

IDT 4.2 Columns Referenced table doesn't have the same data type as in the DB table

573 Views Last edit Jul 01, 2020 at 11:32 AM 3 rev

We are doing the migration in BO 4.2 by changing the data source from Teradata database to AWS Redshift database

BO IDT version: 4.2 Version: 4.2 Support Pack 6 Patch 6)

In Data Foundation layer after inserted the tables and defined its joins. while do the integrity check to table structure showing error as "<Column A> Referenced table <Table A> doesn't have the same data type as in the database table". This error showing only for date field. In DFL layer for the respective date field data type properties mapped as "Undefined" data type. As per the Redshift DB table columns tried by changing the columns data type as date, time, time stamp and other data type such varchar and do the integrity check for table structure. But still the error is showing. Anyone knows or faced this issue please share any work around or going for any patch? Please suggest your ideas to resolve this issue.

Thanks in Advance !!!