| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: Error handling Logic
Answer: How do you handle error logic in Informatica? What are the transformations that you used while handling errors? How did you reload those error records in target? |
| July 07, 2009 04:58:37 |
#3 |
| sahan |
Member Since: July 2009 Total Comments: 10 |
RE: Error handling Logic |
Bad files contains column indicator and row indicator. Row indicator: It generally happens when working with update strategy transformation. The writer/target rejects the rows going to the target
Columnindicator: D -valid o - overflow n - null t - truncate When the data is with nulls, or overflow it will be rejected to write the data to the target The reject data is stored on reject files. You can check the data and reload the data in to the target using reject reload utility. |
| |
Back To Question | |