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




Answers were Sorted based on User's Feedback



Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 milli..

Answer / 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 ?    12 Yes 4 No

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 milli..

Answer / tdguy

Incase if you have priveleges to delete the data, delete
and load all the 4 columns using fload utility. Else use
bteq and load all the 4 columns in a volatile table
followed by delete and loading into target table. But this
would be slow when compared to fload.

Is This Answer Correct ?    3 Yes 0 No

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 milli..

Answer / 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




Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 milli..

Answer / 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

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 milli..

Answer / mohan

I would prefer to go with Multiload utility. Since we are
not sure all the records from flat file are equivalent to
the data which are already stored in teradata database. so
if we use multiload upsert concept we can load newly
available data as well as can update the 4th column. And we
can easily pick up the details how many new and how many are
updated, etc., etc., Please let me know if it makes sense!!!

Is This Answer Correct ?    1 Yes 1 No

Post New Answer



More Teradata Interview Questions

what is identity columns in TD?

2 Answers   Wipro,


Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 Answers  


What is node? How many nodes and amps used in your previous project?

0 Answers  


What are the different functions included in the server software?

0 Answers  


What is spool space? Why do you get spool space errors?

0 Answers  






Explain the term 'foreign key' related to relational database management system?

0 Answers  


How is MLOAD Teradata Server restarted after execution?

0 Answers  


I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,


id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,


Why FLOAD does not support multiset tables??

3 Answers   Tesco, TCS,


What are the different table types supported by teradata?

0 Answers  


Explain the term 'columns' related to relational database management system?

0 Answers  






Categories