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 functions performed by bynet?
Explain fallback in teradata?
What is difference between user and database in teradata?
What is meant by a Virtual Disk?
Mention a few of the ETL tools that come under Teradata.
Highlight a few of the advantages that ETL tools have over Teradata.
How to select first n records in teradata?
What is teradata?
What is the use of virtual processor connectivity in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
what are the day to day activities of teradata DBA ?
How does hashing happens in teradata?
Why does varchar occupy 2 extra bytes?
What does Amp contain and what are all the operations that it performs?
What are the various indexes in teradata? How to use them? Why are they preferred?