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
Name at least 5 different types of transformations used in mapping design and state the use of each.?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the difference between stop and abort in informatica
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain Dataware house architecture .how data flow from intial to end?
What is flashback table ? Advance thanks
What is a code page?
Which is the t/r that builts only single cache memory?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to do the error handling of if ur source is flatfiles?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is a repository? And how to add it in an informatica client?
What is a filter transformation and why it is an active one?
According to his methodology what all you need before you build a datawarehouse
How can we create index after completion of load process?
