I am doing an ETL to extract from Sybase and load to Teradata. There are some datatype difference between these two databases. Is there anybody knows what's the rule for the datatype mapping from Sybase to Teradata? For example: Will Datetime in Sybase map to Timestampe in Teradata without changes the values? How about the Smaillint in Sybase? and so on.
Any helps will be great helpful and I really appreciate.