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
- 15263 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Assumptions made:
1.The last column has to be loaded from the file.
2.The file has also got the other three columns with it.
3.Access has been given to create tables.
>>Since, update cannot be used, mload update script may not
be preferable.
>>TPUMP and BTEQ would be slow.
>>So, my option would be
* create new_table as table with no data;
* Use the fastload to load the empty table with the 5
million rows from the file.
* rename table table to old_table;
* rename new_table to table;
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Define views in teradata with syntax.
What is the purpose of joins in teradata and what are the available join types?
What is the difference between teradata and basic rdbms?
What are the design features involved in teradata?
What is bteq script in teradata?
What are the available join types in teradata?
Explain the types of join supports by teradata?
What is logical data model?
Explain and compare pros and cons of start schemas?
What are the primary characteristics of the Teradata.
What can be achieved by using the teradata rdbms?
What is oltp?
What is spool space? Why do you get spool space errors?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
