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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

587


Highlight the need for Performance Tuning.

582


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

674


What is called partitioned primary index (ppi)?

557


What happens when a node suffers a downfall?

665






What do you mean by fastexport in teradata?

555


How many tables can you join in v2r5?

620


What are the steps involved after the disk manager passes the request?

576


What is spool space? Why do you get spool space errors?

509


What is primary index and secondary index?

567


Explain fallback in teradata?

602


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

551


What are the joins in teradata and how many types of joins are there in teradata?

560


How you will check the version of teradata?

576


Difference between star and snowflake schemas?

601