Need some help to handle some error condition.

[rohan77]

Hi,
Is there any way in Informatica to carry out the following process:
We need to load to load into a fact table lets say INVENTORY_FACT by doing a lookup on the ITEM_DIM table to see if the ITEM is present. So lets say we do a lookup on the ITEM_DIM table with the help of the field obtained from the source and the lookup retrieves NULL value (ITEM_KEY is NULL ) since that ITEM is not present in the table.
So is there any way in Informatica that in the same mapping populate the value of the ITEM_NO which is not there in ITEM_DIM table into the ITEM_DIM table and also populate key (ITEM_KEY which is sequence generated )obtained from the ITEM_DIM table into the fact table.

 

[raj4Informatica]

Rohan,

I would do it in this way,In the lookup(connected),put the default value and then Put an expression transformation and sequence generator after lookup(connected), and in the expression transformation check for default value and if it is there then insert the sequence.