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

which option is used to restart the fastexport script ?

2 Answers   TCS,


What do you mean by teradata intelliflex?

0 Answers  


IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  


Which is faster fastload or multiload?

0 Answers  


List out all forms of LOCKS that are available in Teradata.

0 Answers  






I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  


Difference between multiload and tpump?

0 Answers  


Explain how spool space is used.

0 Answers  


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,


What is real time and near real time data warehousing?

0 Answers  


What does sleep function does in fast load?

0 Answers  


Difference between inner join and outer join?

0 Answers  


Categories