Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 9235 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Difference between multiload and tpump?
Which Teradata concept allows more than one model generation?
What is the command in bteq to check for session settings ?
What is the difference between fastload and multiload? Which one is faster?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
Steps to create a data model?
Discuss the advantages of using partitioned primary index in a query?
How can we load single row of data into teradata database. please give me the process.
Explain the most common data types used in teradata?
Highlight the points of differences between the database and user in Teradata.
Explain the term 'row' related to relational database management system?
How can you track login parameters of users in teradata?
Teradata 
