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
- 14218 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 |
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
what is normalization? explain 1st NF, 2nd NF, 3rd NF
How do we implement materialized view?when to use materialized view?
Clarify the utilization of aggregator cache record?
What is active and passive transformation?
What are active transformations? Name them.
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
How can you increase the performance in joiner transformation?
how did u understand business requirement?
write a query to retrieve the latest records from the table sorted by version(scd)
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
Teradata 
