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
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is a standalone command task?
What is lookup transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the reusable transformations?
What are the differences between joiner transformation and source qualifier transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Is there any target staging area in informatica not staging area
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
update strategy transformation in informatica
What are the different ways to implement parallel processing in informatica?
What is flashback table ? Advance thanks
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Separate from an archive server and a powerhouse?