Search code examples
mappinginformaticainformatica-powercenter

Check if value in source flat file exists in target table with Informatica

I have a mapping that filters out a number of IDs from source flat file and then inserts it into target table. I want to add a condition to check whether the ID exists in target table, and if the ID doesn't exist, the row should be added to error file. How can I get this done? I know we can use a dynamic lookup but that will only insert or update into target table, which is not what I want.

Solution

  • Do a normal lookup on the target. If the return value is null, then route it to the error file using a router.