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 |
Explain parsing engine in teradata?
If table have access lock.In the same table write lock is posible or not?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is called partitioned primary index (ppi)?
What is the multi-insert?
write lock is compatiable with which type of lock?
What is TPD?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is the purpose of joins in teradata?
Explain the term 'foreign key' related to relational database management system?
What is collect statistics?
Describe primary index in teradata. And what are the available primary index types?