How do you do error handling in Informatica?
Answer / kishore
Mainly errors were like null values first we need to process error records into one target and good record into another target by using router transformation.after execution of mapping we check the error file size through unix if error file size is greater than 0 then we will send email to source system team with error file attachments.
Is This Answer Correct ? | 1 Yes | 0 No |
What is informatica? Why do we need it?
What are the tuning techniques you applied during your last project
Design time, run time. If you don't create parameter what will happen
How can you change from reusable session into non-reusable session.
without matching columns in two tables. how can you join
What is the difference between Power Centre and Power Mart?
What are active and passive transformations?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is session task and command task?
tell me 5 session failure in real time how can you solve that in your project?
how to duplicates from expression transformation without using sorter before that
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?