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
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 |
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 |
What are teradata utilities?
What are the different functions included in the server software?
Diff b/w v2r5 and v2r6 ?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are different table types used in teradata?
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?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
Why Fload doesn’t support multiset table?
What is multi insert?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
Can you load multiple data files for same target table using fastload?
How does indexing improve query performance?