Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 14399 Views
- Syntel, I also Faced
- E-Mail Answers
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
tell me 5 session failure in real time how can you solve that in your project?
What is the sequence generator transformation in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a joiner transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the guidelines to be followed while using union transformation?
Performance tuning( what you did in performance tuning)
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
lookup transformation with screenshots
what is song in infrmatica...?
On which transformations you created partitions in your project?
Under which circumstances, informatica server creates reject files?
Differentiate between Load Manager and DTM?
Define update strategy?
How can we store previous session logs?
