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???

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.

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 ...

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

How to view and Generate Metadata Reports?

1 Answers  

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---