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
- 13512 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 different threads in DTM process?
I have source like this 1:2;3. so i want to load the target as 123
What is junk dimention?
can a port in expression transf be given the name DISTINCT
What is the commit type if you have a transaction control transformation in the mapping?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What are the rank caches?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
How you prepared reports for OLAP?
What is the sql query overwrite in source qualifier in informatica
What is the reusable transformation?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
Teradata 
