Convertion from SQL Server to Teradata

General
Enthusiast

Convertion from SQL Server to Teradata

Hi,

   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.

Thanks

4 REPLIES
Enthusiast

Re: Convertion from SQL Server to Teradata

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.

Teradata Employee

Re: Convertion from SQL Server to Teradata

Guys, in SQL Server .... timestamp .... is no where close to DATE and/or TIME.

See below for further details:

http://technet.microsoft.com/en-us/library/ms182776.aspx

Teradata Employee

Re: Convertion from SQL Server to Teradata

Also, you can load it as varchar.

Enthusiast

Re: Convertion from SQL Server to Teradata

Used convert(varchar(30),cast([column_name] as varbinary(30)),1)

Getting correct value in teradata.

Thanks for the help.