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 / pavan
The update is not accessible,so we cannot use the FLOAD
Utility why because FLOAD is the utility only used to
insert that to incae of empty tables only. and we can go
for MLOAD utility.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
When tpump is used instead of multiload?
What is the use of fallback?
Explain the term 'tables' related to relational database management system?
What is the difference between union and union all in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is the difference between fastload and multiload? Which one is faster?
Syntax for case when statement?
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 is sysdba and sysdbc ? which has high priority ?
Highlight the need for Performance Tuning.
What are teradata utilities?
What are the various reporting tools in the market?
What are some commonly used bteq scripts?
How many sessions of MAX is PE capable of handling at a particular time?
What is the purpose of joins in teradata and what are the available join types?