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
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
How do you define Teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is spool space? Why do you get spool space errors?
Why managing the data is important?
What are the multiload utility limitations?
Why is the case expression used in teradata?
What are the string manipulation operators and functions associated with teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Highlight a few of the important components of Teradata?
Explain teradata vs. Redshift?
What are the design features involved in teradata?
What are the uses of bynets in multi-node systems?
What happens when a node suffers a downfall?
What is the primary index in teradata?
What are the different design perspectives used in teradata?