If we execute an query in MLOAD it's ran successfully,
my questions is after successfully ran MLOAD. In error
tables we can see anything there! is it possible than what
are they?
Answers were Sorted based on User's Feedback
Answer / dave bruce
These tables will be dropped automatically when the sql
statement is successful in MLOAD.. MLOAD internally runs a
row count on all the tables participated before it quits
the MLOAD session.. if it finds any it will return the
error code like 8 r 12 depends on the error type..
Is This Answer Correct ? | 0 Yes | 0 No |
THREE COLUMNS SPECIFIC TO THE ACQUISITION ERROR TABLE
Error Code: System code that identifies the error.
Error Field: Name of the column in the target table where
the error happened; is left blank if the offending column
cannot be identified.
Host Data: The data row that contains the error.
THREE COLUMNS SPECIFIC TO THE APPLICATION ERROR TABLE
Uniqueness: Contains a certain value that disallows
duplicate row errors in this table;can be ignored, if desired.
DBC Error Code: System code that identifies the error.
DBC Error Field: Name of the column in the target table
where the error happened; is left blank if the offending
column cannot be identified.
NOTE:A copy of the target table column immediately follows
this column.
Is This Answer Correct ? | 0 Yes | 1 No |
How can we join three tables in SQL server 2000
Datatypes are unlimited,true or false?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What is the difference between oracle and MS Access?
What is meant by distributed system?
Differentiate between extension & intension?
What is difference between clustered, non-clustered and unique index?
What is the difference between primary and candidate key?
what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?
what is tkprof tool and how it is used???
in informatica workflow has 5 sessions and running seqentially and 3rd session has been failed how can we run again from only 3rd to 5th session
How to do Data integrity testing? Who does this testing (Developer or tester)?