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 |
why u go for dimensions ?
What are Dimensions and various types of Dimensions?
What are the challenges of Dataware housing in the future?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
What is a joiner transformation?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
Enlist the tasks for which source qualifier transformation is used.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
Filter transformation in the condition one of the data is NULL would the record be dropped.
what is the Default Source Option For Update Strategy Transformation?
how to obtain performance data for individual transformations.