Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between source qualifier transformations source filter to filter transformation?
How to extract sap data using informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How union transformation is used?
what are 3 tech challenges/ common issues you face?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is different between the data warehouse and data mart?
What is the use of target designer?
What is repository manager?
What does reusable transformation mean?
What are junk dimensions?
What are some examples of informatica etl programs?
How can one identify whether mapping is correct or not without connecting session?
how tokens will generate?
Explain load alternative records / rows into multiple targets - informatica
