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.
Do a lookup on the Item table and match the Feild Item_decription.
If the lookup return any null values for the Item_description then use abort function to abort the session.
IIF ( ISNULL( Item.Item_description) , ABORT("Description values are not available in Item Table"))