Skip navigation
Contact Us
645 Views 2 Replies Latest reply: Nov 8, 2012 6:37 AM by David Shore RSS
David Shore Newbie 6 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.

 

Example

 

Sale Table contains the following fields

sale_date

cost

item_description

 

Item Table contains the following fields

item_number

item_description

 

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.

 

Thanks

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

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