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
- 15240 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
Why is the case expression used in teradata?
List out all forms of LOCKS that are available in Teradata.
What are some primary characteristics of teradata?
Explain the term 'primary key' related to relational database management system?
What is the basic syntax for teradata select statement?
What interface is used to connect to windows based applications?
Differentiate database data and data warehouse data?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is a level of granularity of a fact table?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the various indexes in teradata? Why are they preferred?
What is TPD?
How to load specific no.of records using bteq, or fastload,or multiload
