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
What is the purpose of joins in teradata and what are the available join types?
Explain the term 'columns' related to relational database management system?
How to select first n records in teradata?
Describe primary index in teradata?
What are the various indexes in teradata? How to use them?
What do high confidence, low confidence and no confidence mean in explain plan?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is the purpose of using case expression in teradata?
What is meant by a Virtual Disk?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Explain the advantages of partitioned primary index in a query?
What happens when a node suffers a downfall?
What is upsert statement in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Difference between stored procedure and macro?