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 would you copy the content of one repository to another repository?
What is factless fact schema?
How to delete first 3 rows & last 3 rows in target table in informatica
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
how to obtain performance data for individual transformations.
how to move the mappings from your local machine to claint place?
What is the Router transformation?
generate date / time dimension in informatica
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
How do we call shell scripts from informatica?
How can you recover the session in sequential batches?
Is informatica power center designer has 64 bit support?