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
- 15215 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
How will you solve the problem that occurs during update?
What are the available primary index types in teradata.
What are the primary characteristics of the Teradata.
Describe the set operators in teradata.
What is the maximum number of dml can be coded in a multiload script?
What are the functions of a Parser?
any one answer me how they can analyzing the project using data ware housing?
Write a program to show the parser component used in teradata?
What do you mean by teradata intellicloud?
What is the difference between fastload and multiload?
Highlight all the modes that are present under Confidence Level.
Discuss the advantages of using partitioned primary index in a query?
How do you see a ddl for an existing table?
What are the functions involved in shared information architecture?
What are the multiload utility limitations?
