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 |
If the table does not have duplicates then which utility you can suggest to load the data ?
Explain some differences between mpp and smp?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
How will you solve the problem that occurs during update?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
What are the multiload utility limitations?
teradata support to automatically increase the character length or not?
What are some primary characteristics of teradata?
What is the difference between correlated sub queries and inner queries?
How to Extract data from multiple legacy systems?
What is the difference between fastload and multiload? Which one is faster?
Discuss the advantages of using partitioned primary index in a query?