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
- 14405 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 reusable transformations in how many ways we can create them?
Explain the different lookup methods used in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
one source to target loading insert new rows and update existing rows?
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
what is the difference between copy object import objects using repositery manager which one is best
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the use of code page?
What is the difference between a router and a filter transformation?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
what is the mechanism of the Master-Detail joining condition?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
Teradata 
