GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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