what is the structure of UV table in MLOAD?
Answers were Sorted based on User's Feedback
Answer / preetam
ImportSeq--DMLSeq--SMTSeq--ApplySeq--SourceSeq--Uniqueness
--DBCErrorCode
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / yuvaevergreen
ApplySeq-DBCErrorCode-DBCErrorField-DMLSeq-ImportSeq-SourceSeq-SMTSeq-Uniqueness
SourceSeq- used to identify the error row in source file
DBCErrorField - used to find the error column in target table
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / shirisha9
import seq
dml seq
stmtseq
apply seq
sourceseq
uniqueness
dbc error code
dbc error field
| Is This Answer Correct ? | 1 Yes | 1 No |
what is use of PI(primary index) AND SI(secondary index)
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
How to run the Teradata jobs in unix environment ???
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 is the difference between fastload and multiload?
What is SQL Assistence?please eample
Difference between stored procedure and macro?
How to view every column and the columns contained in indexes in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What is a node in teradata? Explain
Why Fload doesn’t support multiset table?