This video explains how to troubleshoot incompatible data types conversion in PowerCenter Designer.
References:
• Designer Guide - Sybase and Transformation Datatypes
https://docs.informatica.com/data-integration/powercenter/10-4-0/designer-guide/datatype-reference/sybase-and-transformation-datatypes.html
• Designer Guide - Port-to-Port Data Conversion
https://docs.informatica.com/data-integration/powercenter/10-4-0/designer-guide/datatype-reference/converting-data/port-to-port-data-conversion.html
• Sybase Infocenter: Date, Time, Datetime, and Timestamp Data Types
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1602/doc/html/san1278453537588.html
Expertise – Beginner
User type – Developer
Category – Administration
Project Phase – Configure
Problem Type – Product Feature
Keywords:
H2TS, sybase, ase, iq, jconn4, dbisql, timestamp, string, date, datetime, data type, conversion, designer, link, mapping, validation, transformation datatypes, data conversion, binary, varbinary
How to automate the repository and domain back up process for disaster recovery in PowerCenter
How to unassign services from an expired key and assign them to a valid key in 9.1.0 and 9.5.1
How to find in which host the Repository Integration service is running in a multi node domain