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 |
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.
What are differences between teradata and ansi session modes in teradata?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
What is the purpose of joins in teradata and what are the available join types?
Differentiate database data and data warehouse data?
Highlight the points of differences between the database and user in Teradata.
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
what is the difference between bpo and call centre?
Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q
What is meant by a Parsing Engine?