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
- 15459 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
Explain some differences between mpp and smp?
What are the different functions performed in development phase?
What is the meaning of Caching in Teradata?
any one answer me how they can analyzing the project using data ware housing?
What are the various reporting tools in the market?
Explain how spool space is used.
Describe primary index in teradata?
What does Amp contain and what are all the operations that it performs?
How to Extract data from multiple legacy systems?
What is the multi-insert?
Different phases of multiload?
How to find duplicates in a table?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
