Informatica badfiles will have the row indicator columns which can take values between 0 to 9 and Please find the details as below:
RowIndicator Meaning Rejected By
0 Insert Writer or target
1 Update Writer or target
2 Delete Writer or target
3 Reject Writer
4 Rolled-back insert Writer
5 Rolled-back update Writer
6 Rolled-back delete Writer
7 Committed insert Writer
8 Committed update Writer
9 Committed delete Writer
Also you can focus on column indicators, and the details are as below:
Indicator Type of data Writer Treats As
D Valid data. Good data. Writer passes it to the target database. The target accepts it unless a database error occurs, such as finding a duplicate key.
O Overflow Numeric data exceeded the specified precision or scale for the column. Bad data, if you configured the mapping target to reject overflow or truncated data.
N Null The column contains a null value. Good data. Writer passes it to the target, which rejects it if the target database does not accept null values.
T Truncated String data exceeded a specified precision for the column, so the PowerCenter Server truncated it. Bad data, if you configured the mapping target to reject overflow or truncated data.
Wednesday, September 24, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment