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
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
What are the steps involved in the process flow of the sql statement through channel attached system?
how can we analyze the locks ?
What are the available join types in teradata?
What is spool space?
What are the things to be considered while creating secondary index?
Highlight the differences between Primary Key and Primary Index.
What is the purpose of indexes?
What is database exceptions in teradata?
List out teradata data types?
What are the available primary index types in teradata.
What are the advantages of teradata?
What are aggregate tables? How do you design them using teradata?
What is a sparse index?
What are the multiload utility limitations?
How do you see a ddl for an existing table?