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
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?
Difference between star and snowflake schemas?
Explain the term 'foreign key' related to relational database management system?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are the advantages of teradata?
How to select first n records in teradata?
How do you do backup and recovery in teradata?
Explain teradata vs. Redshift?
During the Display time, how is the sequence generated by Teradata?
Did you write stored procedures in teradata?
In Teradata, how do we Generate Sequence?
What is upsert statement in teradata?
What are teradata utilities?
What is TPD?
What is smp and mpp platforms?