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
- 15208 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
Mention a few of the ETL tools that come under Teradata.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
List out some of the primary characteristics of teradata.
Highlight the differences between Primary Key and Primary Index.
What are normalization, first normal form, second normal form and third normal form?
What are the advantages of teradata?
Discuss the advantages of using partitioned primary index in a query?
Explain amp in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What happens when a node suffers a downfall?
What is basic teradata query language?
Which is faster fastload or multiload?
What are default access rights in teradata?
Define views in teradata with syntax.
Explain the term 'tables' related to relational database management system?
