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
335 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
Informatica: How to get MIDDLE Data from a FILE?

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
Informatica Repository Query to get Lookup Connection

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
How to copy the data loaded into target table from source table to the text file?

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
Informatica: In unconnected lookup what are other transformations that can be used in place of expression transformation

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

...