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
- 14955 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 are types of partition primary index (ppi) in teradata?
What are normalization, first normal form, second normal form and third normal form?
List out teradata data types?
What are aggregate tables? How do you design them using teradata?
How can we check the version of Teradata that we are using currently?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is the use of fallback?
In Teradata, how do we Generate Sequence?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What can be achieved by using the teradata rdbms?
Explain the term 'tables' related to relational database management system?
During the Display time, how is the sequence generated by Teradata?
What are the functions performed by bynet?
Highlight a few of the important components of Teradata?
