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 |
How will you solve the problem that occurs during update?
In Teradata, how do we Generate Sequence?
How to Extract data from multiple legacy systems?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Explain how spool space is used.
Explain teradata vs. Redshift?
How to relege locks in fastload and multiload? example?
List out some of the primary characteristics of teradata.
How can you track login parameters of users in teradata?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Explain teradata utilities. What is multiload, fast load, tpump?