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

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

how did u understand business requirement?

2 Answers   TCS,

---

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers   Puma,

---

What are events in workflow manager?

1 Answers   Accenture, IBM,

---

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?

0 Answers   Bosch,

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

---

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

---

What is difference between maplet and reusable transformation?

2 Answers  

---

Which kind of index is preferred in DWH?

3 Answers  

---

What is domain in terms of informatica?

0 Answers  

---

replace multiple spaces with single space.

3 Answers   IBM,

---