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

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

3 Answers
6297 Views
CTS, I also Faced
E-Mail Answers

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

Write a query to get maximum and second maximum in oracle?

0 Answers CGI,

A lowest level of security by most RDBMS is

0 Answers Baan Infotech,

can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 Answers

Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

0 Answers Amazon,

What are different types of data models available? Explain with example?

0 Answers Accenture,

WHAT IS OPM?(IN DETAILED)

1 Answers L&T,

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 ole db source in ssis?

0 Answers

5. Explain about relational algebra.

0 Answers

What is the difference between primary and candidate key?

0 Answers BirlaSoft,

What is a database string?

0 Answers

Is storing images in a database a good idea?

0 Answers

For more Databases AllOther Interview Questions Click Here