top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
272 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 LinkedIn 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?

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

+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

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

...