top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration
Print Preview

Rejected rows into a bad file, how to avoid that when using Informatica

+1 vote
375 views

I have developed an Informatica PowerDesigner 9.1 ETL Job which uses lookup and an update transform to detect if the target table has the the incoming rows from the source or not. I have set for the Update transform a condition

IIF(ISNULL(target_table_surrogate_id), DD_INSERT, DD_REJECT)

Now, when the incoming row is already in the target table, the row is rejected. Informatica writes these rejected rows into a .bad file. How to prevent this? Is there a way to determine that the rejected rows are not written into a .bad file? Or should I use e.g. a router insted of an update transform to determine if the row is insert row an then discard the other rows?

posted Jul 21, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

2 Answers

+1 vote

Identiffy the new or changed rows, which will be inserted/updateed.

answer Jul 21, 2013 by Shatark Bajpai
+1 vote

If We uncheck option " Forward Rejected Rows " in update strategy transformation then rejected rows won't be logged into bad file.

answer Aug 17, 2013 by Nandan Kumar
Similar Questions
+1 vote

How to transform rows into column using Normalizer in Informatica?

+1 vote

If work flow run on informatica level how to create the automatically file create error records and rejected records in one file.


Useful Links with Similar Problem
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#470/147, 3rd Floor, 5th Main,
HSR Layout Sector 7,
Bangalore - 560102,
Karnataka INDIA.
QUERY HOME
...