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
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 tools would you use for that?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
While creating table my dba has fallback or no fallback in his ddl. What is that?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain fastload in teradata?
What are types of partition primary index (ppi) in teradata?
What is the difference between fastload and multiload?
What are the primary characteristics of the Teradata.
What are the different design perspectives used in teradata?
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?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Difference between star and snowflake schemas?
What are default access rights in teradata? What explicit right can be given to a user?
Explain BYNET.
What is the purpose of upsert command?