Skip navigation
Contact Us
1266 Views 2 Replies Latest reply: Nov 8, 2012 6:37 AM by David Shore RSS
David Shore Newbie 9 posts since
Nov 7, 2012
Currently Being Moderated

Nov 7, 2012 7:59 AM

How to capture dropped records from joiner?

I have a piece of Informatica code that uses a joiner to match on a description to look up a code.

I would like the process to stop if any of the records do not find a match.




Sale Table contains the following fields





Item Table contains the following fields




I need all the item_descriptions in the Sale table to exist in the Item table.  If they do not I need my process to abort/stop/warn-me so that I can do some manual data fixing.



My current map has two sources (Sale table and Item table).  I then use a joiner, joining on item_description to retrieve the item_number.


Any help would be appreciated.



More Like This

  • Retrieving data ...

Bookmarked By (0)


  • Correct Answers - 10 points
  • Helpful Answers - 5 points