How would you load a very large file in teradata in general? What utility would you use for it? Why?
why varchar takes 2 extra bytes?
what is the difference between primary index and secondary index?.
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
in teradata level primary in table level allows duplicates why?
What are the scenarios in which full table scans occurs?
I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
How do you design aggregate tables using teradata?
How do you set the session mode parameters in bteq?
Why Multiload does not supports USI and supports NUSI?
What is the use of having index on table?