Interested to Buy Any Domain ? << Click Here >> for more details...
Hello all,
There is a table with 4 columns in that 3 columns has been
already loaded with 5 million records.4th column is
empty,Now I have got 5 million records data which has to be
loaded into 4th column.How can I load this data fastly in to
the 4th column with out using update
- 5 Answers
- 14946 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answer Posted / tdguy
Incase if you have priveleges to delete the data, delete
and load all the 4 columns using fload utility. Else use
bteq and load all the 4 columns in a volatile table
followed by delete and loading into target table. But this
would be slow when compared to fload.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How many types of joins are there in teradata?
What is the use of stored procedures in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the uses of bynets in multi-node systems?
How to view every column and the columns contained in indexes in teradata?
How do you verify a complicated sql?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the various indexes in teradata?
Which is faster fastload or multiload?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the different softwares used with their functions in teradata?
What are the enhanced features in teradata v2r5 and v2r6?
What's the difference between timestamp (0) and timestamp (6)?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
List out teradata data types?
