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 |
Highlight a few of the advantages that ETL tools have over Teradata.
in teradata level primary in table level allows duplicates why?
What does Amp contain and what are all the operations that it performs?
What is the diffrence between Multiload & Fastload interms of Performance?
What is the purpose of indexes?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
what happen if a query fail in dispatcher?
What is the basic syntax for teradata select statement?
Differentiate database data and data warehouse data?
What is the difference between fastload and multiload?
What's the difference between timestamp (0) and timestamp (6)?
Explain Teradata performance tuning and optimization?