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

How will you solve the problem that occurs during update?

0 Answers  


In Teradata, how do we Generate Sequence?

0 Answers  


How to Extract data from multiple legacy systems?

0 Answers  


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

0 Answers  


Explain how spool space is used.

0 Answers  






Explain teradata vs. Redshift?

0 Answers  


How to relege locks in fastload and multiload? example?

4 Answers   IBM,


List out some of the primary characteristics of teradata.

0 Answers  


How can you track login parameters of users in teradata?

0 Answers  


Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,


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

0 Answers  


Explain teradata utilities. What is multiload, fast load, tpump?

0 Answers  


Categories