Recent content by usatish

Hi, I never worked with oracle...so not aware of scott database. For sure Teradata cannot load directly from oracle. So you will have to export all tables in scott database in text file. Look at the sample files provided in the demo CD's (as mentioned by 'tdatgod'). you can create a table from...

Hi, If ur using the windows client then u nee to make the following entry in Hosts file ( in C:\winnt\system32\driver\etc on NT/2K) <ip of machine where TD is installed> dbc dbcbynetc dbccop1 use .logon dbc/<user id>, <passwd> in fastload or any other utility scripts. I doubt Multiload is...

:-) Well, in a report u can use as many as u wish. Can you please describe ur problem in detail. What the report is? what table structures and what tool r u using? and all other related details. usatish

rohitrivo, Informatica, has support to invoke teradata utilities. what it does is writes the data to text and invokes the teradata utilities to load it further. As suggested by namder SAS/ACCESS has the native support to Fastload utility only and fastload can load data only in empty tables...

If you have used FastExport to export the data file, you have an option of generating mload script for loading the same file back to teradata. Open this mload file in editor and make changes as per your desired target database and run the script. I hope this should help you. usatish

Well, There is no direct way of generating the sequence (i don't know if they got this option in V2R4) However, you can achive it using &quot;RANK&quot; function For example Sel firt_name, last_name, Rank(<primary key of table>) From blah blah.. Satish