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?
- 3 Answers
- 4862 Views
- CTS, I also Faced
- E-Mail Answers
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
can we delete autodiff back up that we have set through sql server agent.
Is hive a database?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
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)?
What is Object Oriented model?
What is a driver in database?
What is ase database?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
What are database connection details?
Is redis in memory database?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
what is tkprof tool and how it is used???
Is database a hardware or software?
Explain alternate key?
what is data access layer?
