1. Categories >> Software >> Databases >> Databases AllOther
  2. Suggest New Category

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?

Question Posted / svjkumar1986

Answers were Sorted based on User's Feedback



If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran ..

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.

Is This Answer Correct ?    0 Yes 0 No

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran ..

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

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran ..

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.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Databases AllOther Interview Questions

What is the difference between database and server?

0 Answers  

Is it good to store images in database?

0 Answers  

What is redis good for?

0 Answers  

What is relational database with example?

0 Answers  

What is Data Modelling?

0 Answers   Informatica,




How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

0 Answers  

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

0 Answers   TCS,

Explain the various types of normalization.

0 Answers  

Integrity constraints means..? how many and what are they?

4 Answers   AZTEC,

1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

0 Answers  

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

0 Answers   3i Infotech,

What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

0 Answers   BDI Systems, Google,

For more Databases AllOther Interview Questions Click Here
Categories