Can anyone please help me out,In which transformations records
will be rejected and how capture those records?and How to
reload the rejected records?
Answer Posted / sreedhar lokaray
There is no such transformation which can handle reject
records. In reconciliation and validation process we
generally reject the records upon not meeting certain
criteria and load them into error log (files or tables).
These logs are later verified and the rejected records are
reloaded after making corrections.
As a simple example if we define the criteria that an
employee record where salary =0 or null should not be
loaded into the target table will be routed to the reject
table/error log using a router transformation.
Hope this clears your question.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How can one identify whether mapping is correct or not without connecting session?
How might you approve all mappings in the archive all the while?
What does “tail –f” command do and what is its use as an Informatica admin.
is it possible to index the data in cache of lkp transformation ?
What is complex mapping?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How do you set a varible in incremental aggregation
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Which are the different editions of informatica powercenter that are available?
What is the meaning of decode in informatica?
Implementation methodology
What is joiner change?
Is it possible to create multiple domains on a single Informatica server?
Define mapplet?
Explain the scenario which compels informatica server to reject files?