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 / yuvaevergreen
Assumptions made:
1.The last column has to be loaded from the file.
2.The file has also got the other three columns with it.
3.Access has been given to create tables.
>>Since, update cannot be used, mload update script may not
be preferable.
>>TPUMP and BTEQ would be slow.
>>So, my option would be
* create new_table as table with no data;
* Use the fastload to load the empty table with the 5
million rows from the file.
* rename table table to old_table;
* rename new_table to table;
Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
What is meant by a node?
What is a sparse index?
What tools would you use for that?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is the maximum number of dml can be coded in a multiload script?
What are the main components of teradata system?
Differentiate database data and data warehouse data?
What are the string manipulation operators and functions associated with teradata?
What is upsert statement in teradata?
What do you mean by tpt in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is the meaning of Caching in Teradata?
How is the teradata different from oracle?
Difference between star and snowflake schemas?
Why managing the data is important?