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
- 15471 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
How can you track login parameters of users in teradata?
What's the difference between timestamp (0) and timestamp (6)?
What is bteq script in teradata?
What is the difference between fastload and multiload?
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?
What is spool space?
What are the scenarios in which full table scans occurs?
What are the uses of bynets in multi-node systems?
Explain the term 'columns' related to relational database management system?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are differences between teradata and ansi session modes in teradata?
What is a dimension table?
In BTEQ, how are the session-mode parameters being set?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
