Answer / hariharan

Mload is designed in a way that the error tables are
automatically dropped once the utility ran successfully. If
the job fails during mload, we can see the error tables with
the help of Errorcode, errorfield, uniqueness attributes.

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..

Answer / 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.

can u combine pipeline parallelism and partition parallalism? how and whan?

0 Answers   TCS,

---

What is database client?

0 Answers  

---

what is primary key,unique key, foreign key? can u teach me in simple language?

44 Answers   Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

---

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

0 Answers  

---

what is vlook up in ms excel and how does it used???

1 Answers   CybAge,

---

Its possible to use auto increment in oracle or not? If no means why?

1 Answers  

---

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?

1 Answers   OVGU,

---

What is a database connection string?

0 Answers  

---

if i want to display the name of students such that to which city they belong must have count greaer than two

0 Answers   Atos Origin,

---

Can a database table exist without a primary key?

0 Answers  

---

Is it possible to update AS400 database record while reading it with no lock

1 Answers  

---

List some advantages of dbms.

0 Answers  

---