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 |
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
How many macros we can create inside a macro
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
How many tables can you join in v2r5?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the functions of a teradata dba?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
what happen if a query fail in dispatcher?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What happens when a node suffers a downfall?
Difference between Qualify and group