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
- 13232 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
Explain PDE.
What are the enhanced features in teradata v2r5 and v2r6?
What are the various reporting tools in the market?
Why are oltp database designs not generally a good idea for a data warehouse?
Explain some differences between mpp and smp?
If a Node is busy what are the steps you can take to avoid ?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
List out teradata data types?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are default access rights in teradata?
What is inner join and outer join?
What is collect statistics?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How do you see a ddl for an existing table?
What is a three-tier data warehouse?
