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
- 12870 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / maheedhar
Hi Sreedhar,
I got it,but what i mean to say is,in update strategy and router we will have rejected records and we can capture these records and reload them?How these things goes on,kindly explain me briefly???
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
Answer / ankur saini er.ankur861@gmail.
Hi Maheedhar,
we have a reject loader concept in informatica to load the
rejected rows from the log/file.
even i havnt used it so for ....so just mentioned here so
that you can also so some research on this and please share
to here ...
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the tasks that Loadmanger process will do?
How can i send first half of the records to one target and Remaining to other target?
SO many times i saw "$PM parser error " .what is meant by PM?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
Enlist some properties of sessions.
How can we remove the duplicates from flat file source?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What is pmcmd command?
If we are using an aggregator but forget to mention the group by port .what will be the output??
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
Teradata 
