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 many types of dimensions are available in informatica?
What are the various types of transformation?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
without dynamic lookup transformation how to insert new rows and update existing rows?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
How many number of sessions can one group in batches?
How can one identify whether mapping is correct or not without connecting session?
What are Dimensions and various types of Dimensions?
How to create or import flat file definition in to the warehouse designer?
How to jion 2 tables, without using any condition?
How we can create indexes after completing the load process?