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

Facebook Login
Site Registration

Sending source data that fails to get a row from Lookup T/F

+1 vote
91 views

I have look up T/F in the mapping. If the look up t/f fails to return a row based on the look up condition, i need to send the source record to Bad file. How can i do that?

posted May 7, 2014 by Rohini Agarwal

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

1 Answer

0 votes

Add an Update Transformation with a condition like:

IIF(ISNULL(lkp_Id), DD_REJECT, DD_INSERT)

Where lkp_Id is a name of port fetched by lookup transformation.

answer May 9, 2014 by Shweta Singh
Similar Questions
0 votes

I have 20 records in a file and I don't need the first and the last line, I need data from 2 through 19 lines only.
How can I achieve this?

+1 vote

I have to load the target table copy of data into the text file at the time of workflow running.(i.e)Whatever data are going into the the target table that should come into the text file also.

+2 votes

Within Informatica I have a Mapping which uses a unconnected lookup. This Mapping I use in a Session wherein I define a Relational DB connection for this lookup transformation.

Now, which repository tables will I have to query to get the connection names for all my lookups in my sessions? I tried REP_SESS_WIDGET_CNXS, but there are only connection names for sources and targets of my sessions.

Any idea on this one?

+2 votes

In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...