Hi,

1.   I have productDetails Table with ProductID and ProductName columns
2.   The productDetails table is my lookup table. I have given input port product_id (from another source) and in lookup expression condition given ProductID = product_id.
3.   When product_id does not exist in product table, the lookup will return productName as null value.
4.   I wanted to skip this meaning When the product id does not exists in lookup table then I don’t want to keep product name as null in target.

Can anyone pls tell me how to avoid?

Regards,

Sankar. S

Hi,
Not able to follow your words "look up table data it will reject it". Pls explain with an example which would help to understand easily.

The actual scenario is very simple,
-----------------------------
Lookup Table: ProductDetails
-----------------------------   
ProductID   ProductName
=========================
1234                 Lux
1235                 Hamam

I will pass ProductID 1234 and get /return productName (now Lux). 
in TargetTable the value would be

ProductCode   ProductDescription
============================
1234                    Lux


But if I pass productId value 3333 then I will get productName which is nothing but null since the product id does not exist in lookup table.

Now the target table.

ProductCode   ProductDescription
============================
1234                      Lux
3333   

Now my question is how to avoid to keep null value in ProductDescription.  Is there any way to handle this problem in lookup transformation itself instead of using any addtional transformation.

Regards,
Sankar. S