Informatica BDM 10.2, developer tool.
We have thousands of tables imported from MSSQL to informatica as data objects.
When we were trying to use these objects in mapping as source, we found that all fileds with data/datetimeoffset data type would be read as varchar(0), then we have to manually adjust the data type one by one.
We did found two posts here as below links, but I'm not sure why is this the case?
So this is still an unsupported data type, or a bug, or ODBC connecting issue?
Is there any way to adjust the datatype in a batch to reduce labor?
You were getting varchar(0) issue before as Date Data type was not supported in SQL Server. Effective in version 10.2 HotFix 1, you can read or write the date data type when you use the Microsoft SQL Server connection in an Informatica mapping.
Let me know If this helps.