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
- 15443 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
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Highlight the advantages of PPI(Partition Primary Index).
What is the difference between teradata and oracle?
What is teradata? What are some primary characteristics of teradata?
What is difference between user and database in teradata?
Explain fastload in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What does Amp contain and what are all the operations that it performs?
Where is teradata rdbms used?
How do you determine the number of sessions?
What is logical data model?
Explain the advantages of partitioned primary index in a query?
What are the various indexes in teradata? How to use them?
Explain PDE.
