All Forums General
spkother 18 posts Joined 07/13
17 Apr 2014
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
 

Raja_KT 1246 posts Joined 07/09
18 Apr 2014

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.
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Adeel Chaudhry 773 posts Joined 04/08
18 Apr 2014

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

-- If you are stuck at something .... consider it an opportunity to think anew.

Adeel Chaudhry 773 posts Joined 04/08
18 Apr 2014

Also, you can load it as varchar.

-- If you are stuck at something .... consider it an opportunity to think anew.

spkother 18 posts Joined 07/13
12 May 2014

Used convert(varchar(30),cast([column_name] as varbinary(30)),1)
Getting correct value in teradata.
Thanks for the help.

You must sign in to leave a comment.