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?

Answer Posted / svjkumar1986

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain entity set?

772


What is difference between server and database?

768


Can you tell any two advantages of stored procedures?

803


Is storing images in a database a good idea?

752


what are wrappers and build ups and what it's use?

1916


What is a super key?

817


What does specialization in DBMS mean?

842


What are different types of resources?

745


How do I manually create a database?

795


How many indexes can be created on a table?

827


What is the best database?

735


Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

1637


What is the advantage of varchar2 over char?

1015


Explain about ur projets on teradata???

1536


Explain artificial key?

938