If the script is aborted. why it is aborted and how can you identify ?
Answer / tdguy
Just looking at the logs of bteq or mload, we would be able
to know about the error code or type of error. This would
be enough to identify the error.
| Is This Answer Correct ? | 4 Yes | 0 No |
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain teradata vs. Redshift?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
what is amp plz explanation
What are the updated features of teradata?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
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 does Amp contain and what are all the operations that it performs?
What is teradata?
what happen if a query fail in dispatcher?