There is a load to the Table every one hour and
24/7.Morning trafic is high, afternoon trafiic is less,
Night trafiic is high.According to this situation which
Utility you use and how do you load,which utility used?

Answers were Sorted based on User's Feedback



There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is ..

Answer / vinay

Tpump is suggestable here
By Using packet size increasing or decreasing we can handle
traffic.

Is This Answer Correct ?    7 Yes 0 No

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is ..

Answer / pr1

TPUMP UTILITY

Is This Answer Correct ?    1 Yes 0 No

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is ..

Answer / yuvaevergreen

BEGIN LOAD
PACK <varies>
RATE <varies>
ERRORTABLE table name;
Using PACK and RATE parameters, the utility can be run.

Is This Answer Correct ?    0 Yes 0 No

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is ..

Answer / tdguy

tpump

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Teradata Interview Questions

Explain parsing engine in teradata?

0 Answers  


If table have access lock.In the same table write lock is posible or not?

1 Answers  


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

0 Answers  


What is called partitioned primary index (ppi)?

0 Answers  


What is the multi-insert?

0 Answers  






write lock is compatiable with which type of lock?

6 Answers   Infosys,


What is TPD?

0 Answers  


What is teradata? Also, list out some of the primary characteristics of teradata.

0 Answers  


What is the purpose of joins in teradata?

0 Answers  


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

0 Answers  


What is collect statistics?

0 Answers  


Describe primary index in teradata. And what are the available primary index types?

0 Answers  


Categories