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
- 15241 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answer Posted / anil
For this question you have to ask clearly is that data
wants to load fresh or they want to load override ,Or is it
same data next time also getting 5 million records .If we
getting same records again 5 million records then use Mload
utility
1) write 2 staments in mload 1st insert into temp table
then again temp table to select only 4th column and insert
into original table(select 4 column) this is one type of
procedure.
2) Then again load by using fast load it will not takes big
time.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is spool space? Why do you get spool space errors?
What are different table types used in teradata?
Explain the term 'primary key' related to relational database management system?
What is the difference between union and union all in teradata?
How to Extract data from multiple legacy systems?
What is bteq utility in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What interface is used to connect to windows based applications?
How is MLOAD Teradata Server restarted after execution?
How do you determine the number of sessions?
What are the updated features of teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is database exceptions in teradata?
What is TPD?
