Wednesday, September 24, 2008

Bad File in informatica

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.