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 transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
Why we need XMLs?
What is the Difference between PowerPlay transformer and power play reports?
what is filelist concept in informatica
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
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 the architecture of any Data warehousing project?
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
Tell me about informatica architecture.
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
How to extract the informatica rejected data?
How can u stop a batch?