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
- 14962 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
What are the multiload utility limitations?
Highlight the points of differences between the database and user in Teradata.
What type of indexing mechanism do we need to use for a typical data warehouse?
List out all forms of LOCKS that are available in Teradata.
Explain fastload in teradata?
What is a three-tier data warehouse?
What is teradata and why it is used?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is the difference between fastload and multiload?
What do you mean by fastexport in teradata?
Explain PDE.
What is stored procedure in teradata?
Explain the parallel data extension in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Highlight the advantages of PPI(Partition Primary Index).
