We are loading data from SQL server to Teradata using informatica.our issue is,there is one timestamp column(contain binary data) in sql server.we need to load into teradata.Tried different options but data is not loading properly.Need advice on this.
I think you have a binary timestamp in sql server. If so, then you can convert that in sql server query itself to string or date, then take it forward.
Guys, in SQL Server .... timestamp .... is no where close to DATE and/or TIME.
See below for further details:
Used convert(varchar(30),cast([column_name] as varbinary(30)),1)
Getting correct value in teradata.
Thanks for the help.