DSXchange

Can you paste the exact query and the error you are getting here.... (as you said it is sparsed lookup, you must be passing a value from the mainstream record)

Have u tried using Modify Stage: u can handle null values in tht stage(use handle_null function)