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?
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 |
Design a mapping to get year of join for each employee.
What is joiner transformation?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What are the challenges of Dataware housing in the future?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
what is constraint based load order
What do you mean incremental aggregation?
What are the differences between source qualifier and joiner transformation?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
What is incremental aggregation?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me