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
- 15216 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
What do you mean by teradata intellicloud?
What is the basic syntax for teradata select statement?
How to view every column and the columns contained in indexes in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
Describe primary index in teradata. And what are the available primary index types?
How many tables can you join in v2r5?
Explain Teradata performance tuning and optimization?
What are the functions involved in shared information architecture?
What is a clique?
Explain vproc in teradata?
Mention a few of the ETL tools that come under Teradata.
What is meant by a Clique?
How can you track login parameters of users in teradata?
What are the different table types supported by teradata?
Explain and compare pros and cons of snow flake schemas?
