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 |
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
What is IQD file?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
How informatica recognizes mapping?
Can we create multiple integration service on single repository?
Describe an informatica powercenter?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
How to import oracle sequence into Informatica?
Using Expression transformation how to remove duplicate records from a relational source?
How do you use reject loader.